APPS.ECE_SPSO_TRANS1 dependencies on CHV_INQ_SV

Line 1387: AND paa.using_organization_id = chv_inq_sv.get_asl_org(

1383: WHERE
1384: paa.vendor_id = l_header_tbl(n_vendor_id_pos).value
1385: AND paa.vendor_site_id = l_header_tbl(n_vendor_site_id_pos).value
1386: AND paa.item_id = g_item_id --Bug 1705597
1387: AND paa.using_organization_id = chv_inq_sv.get_asl_org(
1388: l_header_tbl(n_organization_id_pos).value,
1389: l_header_tbl(n_vendor_id_pos).value,
1390: l_header_tbl(n_vendor_site_id_pos).value,
1391: g_item_id) -- Bug 1705597

Line 1987: AND using_organization_id = chv_inq_sv.get_asl_org(

1983: FROM po_asl_attributes paa
1984: WHERE vendor_id = rec_hdr.vendor_id
1985: AND vendor_site_id = rec_hdr.vendor_site_id
1986: AND item_id = rec_item.item_id
1987: AND using_organization_id = chv_inq_sv.get_asl_org(
1988: rec_hdr.organization_id,
1989: rec_hdr.vendor_id,
1990: rec_hdr.vendor_site_id,
1991: rec_item.item_id);

Line 2211: chv_inq_sv.get_receipt_qty ( rec_item.last_receipt_transaction_id,

2207:
2208: -- DEBUG Sri's proc package name may chg
2209: -- DEBUG comments
2210:
2211: chv_inq_sv.get_receipt_qty ( rec_item.last_receipt_transaction_id,
2212: rec_item.item_id,
2213: rec_item.purchasing_unit_of_measure,
2214: x_last_quantity,
2215: x_shipment_num,