DBA Data[Home] [Help]

APPS.PO_DATATEMPLATE_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 971: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm

967: AND pca.class_status = 'APPROVED'
968: AND pca.classification_id not in
969: (
970: SELECT classification_id
971: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm
972: WHERE psm.party_id = pca.party_id
973: AND psm.mapping_id = pbcr.mapping_id
974: AND pbcr.request_status = 'PENDING'
975: AND pbcr.request_type in ( 'ADD', 'UPDATE' )