APPS.OE_LINE_FULLFILL dependencies on OE_LINE_SETS

Line 240: From oe_line_sets

236: END IF;
237:
238: Select set_id
239: Into l_set_id
240: From oe_line_sets
241: Where line_id = p_line_id;
242:
243: IF l_debug_level > 0 THEN
244: oe_debug_pub.add( 'Yes, part of fulfillment set ' , 5 ) ;

Line 1643: oe_sets and oe_line_sets tables

1639: END Get_Activity_Result;
1640:
1641: /*
1642: This procedure gets all the lines and sets for a given line_id from
1643: oe_sets and oe_line_sets tables
1644: */
1645:
1646: PROCEDURE Get_Fulfillment_Set
1647: (

Line 1658: FROM OE_LINE_SETS OLS, OE_SETS OST

1654: IS
1655:
1656: CURSOR c_set IS
1657: SELECT OLS.LINE_ID, OLS.SET_ID
1658: FROM OE_LINE_SETS OLS, OE_SETS OST
1659: WHERE OLS.LINE_ID = p_line_id
1660: AND OLS.SET_ID = OST.SET_ID
1661: AND OST.SET_TYPE = 'FULFILLMENT_SET';
1662:

Line 1667: FROM OE_LINE_SETS

1663: l_set_id NUMBER;
1664:
1665: CURSOR c_line_set IS
1666: SELECT LINE_ID, SET_ID
1667: FROM OE_LINE_SETS
1668: WHERE SET_ID = l_set_id;
1669:
1670: l_set_index NUMBER := 0;
1671: l_set_tbl Line_Set_Tbl_Type;

Line 4855: from oe_line_sets l,

4851: IF p_set_id IS NOT NULL THEN
4852:
4853: select count(*)
4854: into l_howmany
4855: from oe_line_sets l,
4856: oe_sets s
4857: where l.line_id = p_line_id
4858: and l.set_id = s.set_id
4859: and s.set_id <> p_set_id

Line 4882: from oe_line_sets l1,

4878: p_set_id and another fulfillment set */
4879:
4880: select count(*) -- added for 2525203
4881: into l_howmany
4882: from oe_line_sets l1,
4883: oe_line_sets l2,
4884: oe_sets s1,
4885: oe_order_lines ol
4886: where l1.line_id <> p_line_id

Line 4883: oe_line_sets l2,

4879:
4880: select count(*) -- added for 2525203
4881: into l_howmany
4882: from oe_line_sets l1,
4883: oe_line_sets l2,
4884: oe_sets s1,
4885: oe_order_lines ol
4886: where l1.line_id <> p_line_id
4887: and l1.set_id = s1.set_id

Line 4908: from oe_line_sets l1,

4904: /* check if there is another line which is with p_line_id in l_set_id and at least one other
4905: fulfillment set */
4906: select count(*)
4907: into l_common_sets
4908: from oe_line_sets l1,
4909: oe_line_sets l2,
4910: oe_line_sets l3,
4911: oe_sets s1,
4912: oe_order_lines ol

Line 4909: oe_line_sets l2,

4905: fulfillment set */
4906: select count(*)
4907: into l_common_sets
4908: from oe_line_sets l1,
4909: oe_line_sets l2,
4910: oe_line_sets l3,
4911: oe_sets s1,
4912: oe_order_lines ol
4913: where l1.line_id = p_line_id

Line 4910: oe_line_sets l3,

4906: select count(*)
4907: into l_common_sets
4908: from oe_line_sets l1,
4909: oe_line_sets l2,
4910: oe_line_sets l3,
4911: oe_sets s1,
4912: oe_order_lines ol
4913: where l1.line_id = p_line_id
4914: and l1.set_id = s1.set_id