DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 1006: JAI_OM_WSH_LINE_TAXES ptl ,

1002: SUM (ptl.func_tax_amount) func_tax_amount ,
1003: MIN (ptl.delivery_detail_id) delivery_detail_id
1004: FROM
1005: JAI_OM_WSH_LINES_ALL pl ,
1006: JAI_OM_WSH_LINE_TAXES ptl ,
1007: JAI_CMN_TAXES_ALL jtc
1008: WHERE
1009: ptl.delivery_detail_id = pl.delivery_detail_id AND
1010: pl.order_header_id = p_source_document_id AND

Line 1051: JAI_OM_WSH_LINE_TAXES ptl

1047: SELECT
1048: quantity
1049: FROM
1050: JAI_OM_WSH_LINES_ALL pl ,
1051: JAI_OM_WSH_LINE_TAXES ptl
1052: WHERE
1053: ptl.delivery_detail_id = pl.delivery_detail_id AND
1054: pl.order_header_id = p_source_document_id AND
1055: pl.order_line_id = p_source_document_line_id ;

Line 2035: JAI_OM_WSH_LINE_TAXES ptl

2031: ptl.func_tax_amount ,
2032: ptl.delivery_detail_id
2033: FROM
2034: JAI_OM_WSH_LINES_ALL pl ,
2035: JAI_OM_WSH_LINE_TAXES ptl
2036: WHERE
2037: ptl.delivery_detail_id = pl.delivery_detail_id AND
2038: pl.order_header_id = p_source_document_id AND
2039: pl.order_line_id = p_source_document_line_id;

Line 2065: JAI_OM_WSH_LINE_TAXES ptl

2061: SUM (ptl.func_tax_amount) func_tax_amount ,
2062: MIN (ptl.delivery_detail_id) delivery_detail_id
2063: FROM
2064: JAI_OM_WSH_LINES_ALL pl ,
2065: JAI_OM_WSH_LINE_TAXES ptl
2066: WHERE
2067: ptl.delivery_detail_id = pl.delivery_detail_id AND
2068: pl.order_header_id = p_source_document_id AND
2069: pl.order_line_id = p_source_document_line_id