APPS.PO_VENDOR_SITES_SV dependencies on ECE_TP_DETAILS

Line 1393: l_edi_flag ECE_TP_DETAILS.edi_flag%TYPE;

1389: x_fax_number OUT NOCOPY VARCHAR2,
1390: x_document_num OUT NOCOPY VARCHAR2,
1391: p_retrieve_only_flag IN VARCHAR2) IS
1392: l_tp_header_id PO_VENDOR_SITES.tp_header_id%TYPE;
1393: l_edi_flag ECE_TP_DETAILS.edi_flag%TYPE;
1394: BEGIN
1395:
1396: -- Retrieve the non-EDI tranmission setups.
1397: get_transmission_defaults (

Line 1413: -- outer join with ece_tp_details.

1409: -- since XML takes precedence over EDI.
1410: IF ((x_default_method IS NULL) OR (x_default_method <> 'XML')) THEN
1411:
1412: -- Bug 5593568 Fixed the queries below to use a subquery to handle the
1413: -- outer join with ece_tp_details.
1414:
1415: IF (p_document_type IN ('PO', 'PA')) THEN
1416:
1417: select phv.tp_header_id, nvl(etd.edi_flag,'N')

Line 1429: ece_tp_details etd

1425: and ph.vendor_site_id = pvs.vendor_site_id (+)
1426: and ph.vendor_id = pvs.vendor_id (+)
1427: and ph.po_header_id = p_document_id
1428: ) phv,
1429: ece_tp_details etd
1430: where etd.tp_header_id (+) = phv.tp_header_id
1431: and etd.document_id (+)
1432: = decode(phv.authorization_status,'REQUIRES REAPPROVAL','POCO','POO')
1433: and etd.document_type (+) = phv.type_lookup_code;

Line 1451: ece_tp_details etd

1447: and ph.vendor_id = pvs.vendor_id (+)
1448: and ph.po_header_id = pr.po_header_id
1449: and pr.po_release_id = p_document_id
1450: ) phv,
1451: ece_tp_details etd
1452: where etd.tp_header_id (+) = phv.tp_header_id
1453: and etd.document_id (+)
1454: = decode(phv.authorization_status,'REQUIRES REAPPROVAL','POCO','POO')
1455: and rownum = 1;