DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on PO_CXML_DELIVERTO_ARCH_V

Line 1487: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||

1483:
1484: /*
1485: In cXML the deliverto information is provided as
1486:
1487: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||
1488: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||
1489: ADDRESS: || PO_cXML_DELIVERTO_ARCH_V.all the address tags
1490:

1491: This is a helper function to concatinate all these values.

Line 1488: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||

1484: /*
1485: In cXML the deliverto information is provided as
1486:
1487: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||
1488: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||
1489: ADDRESS: || PO_cXML_DELIVERTO_ARCH_V.all the address tags
1490:

1491: This is a helper function to concatinate all these values.
1492: */

Line 1489: ADDRESS: || PO_cXML_DELIVERTO_ARCH_V.all the address tags

1485: In cXML the deliverto information is provided as
1486:
1487: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||
1488: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||
1489: ADDRESS: || PO_cXML_DELIVERTO_ARCH_V.all the address tags
1490:

1491: This is a helper function to concatinate all these values.
1492: */
1493: Procedure get_cxml_deliverto_info(p_QUANTITY in number, p_REQUESTOR in varchar2,

Line 1920: FROM PO_CXML_DELIVERTO_ARCH_V

1916: l_flag number;
1917:
1918: CURSOR deliverto_cur (headerid number, releaseid number) IS
1919: SELECT REQUESTOR,REQUESTOR_EMAIL
1920: FROM PO_CXML_DELIVERTO_ARCH_V
1921: WHERE PO_HEADER_ID = headerid
1922: AND ((PO_RELEASE_ID is null AND releaseid is null)
1923: OR PO_RELEASE_ID = releaseid
1924: );