DBA Data[Home] [Help]

APPS.JA_JAINVATR_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 102: OE_ORDER_HEADERS_ALL OOHA

98: ROUND(SUM(JISPL.SELLING_PRICE * JISPL.QUANTITY)
99: ,2)
100: FROM
101: JAI_OM_WSH_LINES_ALL JISPL,
102: OE_ORDER_HEADERS_ALL OOHA
103: WHERE OOHA.ORDER_SOURCE_ID = 10
104: AND JISPL.ORDER_HEADER_ID = OOHA.HEADER_ID
105: AND JISPL.ORDER_TYPE_ID = OOHA.ORDER_TYPE_ID
106: AND JISPL.ORGANIZATION_ID = A_ORGANIZATION_ID