APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PO_DIFF_CONFIG

Line 2702: FROM po_entity_differences a,po_diff_config b

2698: WHEN 'QTY_PRICING' THEN 'Quantity Pricing'
2699: WHEN 'SOURCE_DOC' THEN 'Sourcing document'
2700: ELSE SUB_ENTITY_NAME
2701: END ) AS entityName
2702: FROM po_entity_differences a,po_diff_config b
2703: WHERE a.ENTITY_NAME IN ('LINE','LINELOCATION','DISTRIBUTION')
2704: AND a.DOCUMENT_TYPE=b.DOCUMENT_TYPE AND a.ENTITY_NAME=b.ENTITY_NAME AND a.MOD_DOC_SOURCE_NAME =b.MOD_DOC_SOURCE_NAME
2705: AND a.COLUMN_NAME=b.COLUMN_NAME
2706: AND MOD_DOC_PK1_VAL = DOCUMENTID

Line 2832: FROM po_diff_config

2828: FROM dual
2829: WHERE EXISTS (SELECT 1 FROM PO_ENTITY_DIFFERENCES
2830: WHERE MOD_DOC_PK1_VAL = DOCUMENTID AND MOD_DOC_PK2_VAL = DRAFTID
2831: AND DIFF_ID IN (SELECT DISTINCT DIFF_CONFIG_ID
2832: FROM po_diff_config
2833: WHERE SUB_ENTITY_NAME = 'SUPPLIER_DTLS'));
2834: EXCEPTION
2835: WHEN OTHERS THEN
2836: v_vendor_change_flag := NULL;