APPS.PO_VENDOR_SITES_SV dependencies on ECE_TP_DETAILS

Line 1369: l_edi_flag ECE_TP_DETAILS.edi_flag%TYPE;

1365: x_fax_number OUT NOCOPY VARCHAR2,
1366: x_document_num OUT NOCOPY VARCHAR2,
1367: p_retrieve_only_flag IN VARCHAR2) IS
1368: l_tp_header_id PO_VENDOR_SITES.tp_header_id%TYPE;
1369: l_edi_flag ECE_TP_DETAILS.edi_flag%TYPE;
1370: BEGIN
1371:
1372: -- Retrieve the non-EDI tranmission setups.
1373: get_transmission_defaults (

Line 1389: -- outer join with ece_tp_details.

1385: -- since XML takes precedence over EDI.
1386: IF ((x_default_method IS NULL) OR (x_default_method <> 'XML')) THEN
1387:
1388: -- Bug 5593568 Fixed the queries below to use a subquery to handle the
1389: -- outer join with ece_tp_details.
1390:
1391: IF (p_document_type IN ('PO', 'PA')) THEN
1392:
1393: select phv.tp_header_id, nvl(etd.edi_flag,'N')

Line 1405: ece_tp_details etd

1401: and ph.vendor_site_id = pvs.vendor_site_id (+)
1402: and ph.vendor_id = pvs.vendor_id (+)
1403: and ph.po_header_id = p_document_id
1404: ) phv,
1405: ece_tp_details etd
1406: where etd.tp_header_id (+) = phv.tp_header_id
1407: and etd.document_id (+)
1408: = decode(phv.authorization_status,'REQUIRES REAPPROVAL','POCO','POO')
1409: and etd.document_type (+) = phv.type_lookup_code;

Line 1427: ece_tp_details etd

1423: and ph.vendor_id = pvs.vendor_id (+)
1424: and ph.po_header_id = pr.po_header_id
1425: and pr.po_release_id = p_document_id
1426: ) phv,
1427: ece_tp_details etd
1428: where etd.tp_header_id (+) = phv.tp_header_id
1429: and etd.document_id (+)
1430: = decode(phv.authorization_status,'REQUIRES REAPPROVAL','POCO','POO')
1431: and rownum = 1;