DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on PO_CXML_DELIVERTO_ARCH_V

Line 1484: QUANTITY: PO_cXML_DELIVERTO_ARCH_V.QUANTITY ||

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

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

Line 1485: NAME: || PO_cXML_DELIVERTO_ARCH_V.REQUESTOR ||

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

1488: This is a helper function to concatinate all these values.
1489: */

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

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

1488: This is a helper function to concatinate all these values.
1489: */
1490: Procedure get_cxml_deliverto_info(p_QUANTITY in number, p_REQUESTOR in varchar2,

Line 1915: FROM PO_CXML_DELIVERTO_ARCH_V

1911: l_flag number;
1912:
1913: CURSOR deliverto_cur (headerid number, releaseid number) IS
1914: SELECT REQUESTOR
1915: FROM PO_CXML_DELIVERTO_ARCH_V
1916: WHERE PO_HEADER_ID = headerid
1917: AND ((PO_RELEASE_ID is null AND releaseid is null)
1918: OR PO_RELEASE_ID = releaseid
1919: );