PACKAGE: APPS.RCV_INSERT_FROM_INL

Source

1 PACKAGE RCV_INSERT_FROM_INL AUTHID CURRENT_USER AS
2 /* $Header: RCVINSTS.pls 120.0.12010000.5 2009/09/24 16:29:54 ebarbosa noship $ */
3 
4   CURSOR c_ship_lines(l_ship_header_id IN NUMBER) IS
5     SELECT sl.ship_line_id,
6            sl.ship_line_source_id,
7            sl.inventory_item_id,
8            sl.txn_qty,
9            sl.txn_uom_code,
10            sl.primary_qty,
11            sl.primary_uom_code,
12            sl.secondary_qty,        -- Bug 8911750
13            sl.secondary_uom_code,   -- Bug 8911750
14            sl.currency_code,
15            sl.currency_conversion_type,
16            sl.currency_conversion_date,
17            sl.currency_conversion_rate,
18            slg.party_id,
19            slg.party_site_id,
20            slg.src_type_code,
21 	     slg.ship_line_group_id,
22            sh.organization_id,
23            sh.location_id,
24            sh.org_id,
25            msi.description AS item_description,
26            msi.segment1 AS item,
27            sh.interface_source_code,
28            sl.interface_source_table,
29            sl.interface_source_line_id,
30 	   lc.unit_landed_cost
31     FROM   inl_ship_lines sl,
32            inl_ship_line_groups slg,
33            inl_ship_headers sh,
34            inl_shipln_landed_costs_v lc,
35            mtl_system_items msi
36     WHERE  msi.inventory_item_id  = sl.inventory_item_id
37     AND    msi.organization_id    = sh.organization_id
38     AND    sl.ship_header_id      = slg.ship_header_id
39     AND    sl.ship_line_group_id  = slg.ship_line_group_id
40     AND    slg.ship_header_id     = sh.ship_header_id
41     AND    lc.ship_line_id        = sl.ship_line_id
42     AND    sh.ship_header_id      = l_ship_header_id
43     AND    slg.src_type_code      = 'PO'
44     ORDER BY slg.ship_line_group_id;
45 
46 
47   TYPE rti_rec_table IS TABLE OF c_ship_lines%ROWTYPE;
48 
49   PROCEDURE insert_rcv_tables (p_int_rec        IN rti_rec_table,
50                                p_ship_header_id IN NUMBER);
51 
52 END RCV_INSERT_FROM_INL;
53