DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on INL_SHIP_LINES_ALL_S

Line 2889: inl_ship_lines_all sl,

2885: pvs.vendor_site_code,
2886: COUNT(*) how_many,
2887: MAX(sl.ship_line_num) max_ship_line_num
2888: FROM
2889: inl_ship_lines_all sl,
2890: po_headers_all ph,
2891: po_line_locations_all pll,
2892: po_vendors pv,
2893: po_vendor_sites_all pvs,

Line 2922: inl_ship_lines_all sl,

2918: CURSOR c_sl_num (pc_party_site_id NUMBER) is
2919: SELECT
2920: sl.ship_line_num
2921: FROM
2922: inl_ship_lines_all sl,
2923: po_headers_all ph,
2924: po_line_locations_all pll,
2925: po_vendors pv,
2926: po_vendor_sites_all pvs,

Line 6079: inl_ship_lines_all_s.NEXTVAL, /* 03 */

6075: nrq_zero_exception_flag /* 79 */ --BUG#8334078
6076: )
6077: SELECT sl.ship_header_id, /* 01 */
6078: sl.ship_line_group_id, /* 02 */
6079: inl_ship_lines_all_s.NEXTVAL, /* 03 */
6080: sl.ship_line_num, /* 04 */
6081: sl.ship_line_type_id, /* 05 */
6082: sl.ship_line_src_type_code, /* 06 */
6083: sl.ship_line_source_id, /* 07 */

Line 7107: inl_ship_lines_all sl,

7103: a.to_parent_table_id
7104: FROM
7105: inl_charge_lines cl,
7106: inl_associations a,
7107: inl_ship_lines_all sl,
7108: inl_ship_line_groups slg,
7109: inl_ship_headers_all sh
7110: WHERE
7111: cl.adjustment_num = 0

Line 7318: inl_ship_lines_all sl,

7314: l_sum_chLnAmt
7315: FROM
7316: inl_adj_charge_lines_v cl,
7317: inl_adj_associations_v a, --BUG#9804065
7318: inl_ship_lines_all sl,
7319: inl_ship_line_groups slg,
7320: inl_ship_headers_all sh
7321: WHERE
7322: a.ship_header_id = sl.ship_header_id

Line 7545: FROM inl_ship_lines_all sl

7541: a.ship_header_id = affected_by_elc_lst(k).ship_header_id
7542: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7543: AND NVL(cl.match_id,cl.match_amount_id) IS NOT NULL --only ALC
7544: AND EXISTS (SELECT 1
7545: FROM inl_ship_lines_all sl
7546: WHERE sl.ship_line_id = a.to_parent_table_id
7547: AND sl.ship_header_id = affected_by_elc_lst(k).ship_header_id
7548: AND sl.ship_line_group_id = affected_by_elc_lst(k).to_parent_table_id
7549: AND ROWNUM < 2)

Line 7578: FROM inl_ship_lines_all sl

7574: AND cl.charge_amt = 0
7575: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7576: AND NVL(cl.match_id,cl.match_amount_id) IS NOT NULL --only ALC
7577: AND EXISTS (SELECT 1
7578: FROM inl_ship_lines_all sl
7579: WHERE sl.ship_line_id = assoc.to_parent_table_id
7580: AND sl.ship_header_id = affected_by_elc_lst(k).ship_header_id
7581: AND sl.ship_line_group_id = affected_by_elc_lst(k).to_parent_table_id
7582: AND ROWNUM < 2)

Line 11314: inl_ship_lines_all_s.nextval, -- 03

11310: new_currency_conversion_rate -- 81
11311: )
11312: (SELECT p_ship_header_id, -- 01
11313: sl.ship_line_group_id, -- 02
11314: inl_ship_lines_all_s.nextval, -- 03
11315: sl.ship_line_num, -- 04
11316: sl.ship_line_type_id, -- 05
11317: sl.ship_line_src_type_code, -- 06
11318: sl.ship_line_source_id, -- 07

Line 12054: inl_ship_lines_all sl

12050:
12051: SELECT COUNT(1)
12052: INTO l_rcv_running
12053: FROM rcv_transactions_interface rti,
12054: inl_ship_lines_all sl
12055: WHERE rti.transaction_type = 'RECEIVE'
12056: AND rti.processing_status_code = 'RUNNING'
12057: AND rti.lcm_shipment_line_id = sl.ship_line_id
12058: AND sl.ship_header_id = p_ship_header_id;