SELECT i.application_id,
i.user_name,
bi.interface_name,
i.integrator_code,
bi.upload_param_list_code,
ba.attribute_code,
ba.attribute1,
ba.attribute2,
l.layout_code
FROM bne_integrators_vl i,
bne_layouts_b l,
bne_interfaces_b bi,
bne_param_lists_b bpl,
bne_attributes ba
WHERE 1 = 1
AND i.user_name = 'General Ledger - Historical Rates' -- <<WebADI Name>>
AND bi.integrator_code = i.integrator_code
AND i.integrator_code = l.integrator_code
AND bi.upload_param_list_code = bpl.param_list_code
AND bpl.attribute_code = ba.attribute_code
Attribute1 holds package or procedure used in WebADI.
i.user_name,
bi.interface_name,
i.integrator_code,
bi.upload_param_list_code,
ba.attribute_code,
ba.attribute1,
ba.attribute2,
l.layout_code
FROM bne_integrators_vl i,
bne_layouts_b l,
bne_interfaces_b bi,
bne_param_lists_b bpl,
bne_attributes ba
WHERE 1 = 1
AND i.user_name = 'General Ledger - Historical Rates' -- <<WebADI Name>>
AND bi.integrator_code = i.integrator_code
AND i.integrator_code = l.integrator_code
AND bi.upload_param_list_code = bpl.param_list_code
AND bpl.attribute_code = ba.attribute_code
Attribute1 holds package or procedure used in WebADI.
No comments:
Post a Comment