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 1562: oe_sets and oe_line_sets tables

1558: END Get_Activity_Result;
1559:
1560: /*
1561: This procedure gets all the lines and sets for a given line_id from
1562: oe_sets and oe_line_sets tables
1563: */
1564:
1565: PROCEDURE Get_Fulfillment_Set
1566: (

Line 1577: FROM OE_LINE_SETS OLS, OE_SETS OST

1573: IS
1574:
1575: CURSOR c_set IS
1576: SELECT OLS.LINE_ID, OLS.SET_ID
1577: FROM OE_LINE_SETS OLS, OE_SETS OST
1578: WHERE OLS.LINE_ID = p_line_id
1579: AND OLS.SET_ID = OST.SET_ID
1580: AND OST.SET_TYPE = 'FULFILLMENT_SET';
1581:

Line 1586: FROM OE_LINE_SETS

1582: l_set_id NUMBER;
1583:
1584: CURSOR c_line_set IS
1585: SELECT LINE_ID, SET_ID
1586: FROM OE_LINE_SETS
1587: WHERE SET_ID = l_set_id;
1588:
1589: l_set_index NUMBER := 0;
1590: l_set_tbl Line_Set_Tbl_Type;

Line 4624: from oe_line_sets l,

4620: IF p_set_id IS NOT NULL THEN
4621:
4622: select count(*)
4623: into l_howmany
4624: from oe_line_sets l,
4625: oe_sets s
4626: where l.line_id = p_line_id
4627: and l.set_id = s.set_id
4628: and s.set_id <> p_set_id

Line 4651: from oe_line_sets l1,

4647: p_set_id and another fulfillment set */
4648:
4649: select count(*) -- added for 2525203
4650: into l_howmany
4651: from oe_line_sets l1,
4652: oe_line_sets l2,
4653: oe_sets s1,
4654: oe_order_lines ol
4655: where l1.line_id <> p_line_id

Line 4652: oe_line_sets l2,

4648:
4649: select count(*) -- added for 2525203
4650: into l_howmany
4651: from oe_line_sets l1,
4652: oe_line_sets l2,
4653: oe_sets s1,
4654: oe_order_lines ol
4655: where l1.line_id <> p_line_id
4656: and l1.set_id = s1.set_id

Line 4677: from oe_line_sets l1,

4673: /* check if there is another line which is with p_line_id in l_set_id and at least one other
4674: fulfillment set */
4675: select count(*)
4676: into l_common_sets
4677: from oe_line_sets l1,
4678: oe_line_sets l2,
4679: oe_line_sets l3,
4680: oe_sets s1,
4681: oe_order_lines ol

Line 4678: oe_line_sets l2,

4674: fulfillment set */
4675: select count(*)
4676: into l_common_sets
4677: from oe_line_sets l1,
4678: oe_line_sets l2,
4679: oe_line_sets l3,
4680: oe_sets s1,
4681: oe_order_lines ol
4682: where l1.line_id = p_line_id

Line 4679: oe_line_sets l3,

4675: select count(*)
4676: into l_common_sets
4677: from oe_line_sets l1,
4678: oe_line_sets l2,
4679: oe_line_sets l3,
4680: oe_sets s1,
4681: oe_order_lines ol
4682: where l1.line_id = p_line_id
4683: and l1.set_id = s1.set_id