DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 2458: ELSIF (l_source_distribution_type ='PO_REQ_DISTRIBUTIONS_ALL') THEN

2454: WHEN NO_DATA_FOUND THEN
2455: log(l_module, 'No data found for distribution id(2) '
2456: ||l_source_distribution_id_num_1);
2457: END;
2458: ELSIF (l_source_distribution_type ='PO_REQ_DISTRIBUTIONS_ALL') THEN
2459: l_reference_1 := 'REQ';
2460: --l_reference_3 := l_source_distribution_id_num_1;
2461: BEGIN
2462: log(l_module,'l_sla_entity_id: '||l_sla_entity_id);

Line 2502: FROM po_req_distributions_all pod,

2498: SELECT poh.requisition_header_id,
2499: poh.segment1
2500: INTO l_reference_2,
2501: l_reference_4
2502: FROM po_req_distributions_all pod,
2503: po_requisition_headers_all poh,
2504: po_requisition_lines_all pol
2505: WHERE pod.distribution_id = l_source_distribution_id_num_1
2506: AND pol.requisition_header_id = poh.requisition_header_id