eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_GENESIS_UTIL dependencies on OE_SETS

Line 2898: -- derive its arrival_set_id from table: oe_sets;

2894: -- In this case, we:
2895: -- check whether p_x_line_rec.arrival_set is not-null;
2896: IF p_x_line_rec.arrival_set IS NOT NULL THEN
2897:
2898: -- derive its arrival_set_id from table: oe_sets;
2899: SELECT DISTINCT set_id INTO l_old_arrival_set_id
2900: FROM oe_sets
2901: WHERE set_type = 'ARRIVAL_SET'
2902: AND header_id = p_x_line_rec.header_id

Line 2900: FROM oe_sets

2896: IF p_x_line_rec.arrival_set IS NOT NULL THEN
2897:
2898: -- derive its arrival_set_id from table: oe_sets;
2899: SELECT DISTINCT set_id INTO l_old_arrival_set_id
2900: FROM oe_sets
2901: WHERE set_type = 'ARRIVAL_SET'
2902: AND header_id = p_x_line_rec.header_id
2903: AND set_name = p_x_line_rec.arrival_set;
2904:

Line 2948: l_old_arrival_set oe_sets.set_name%TYPE := null;

2944: -- implemented during 10171747.
2945: /*
2946: IF p_x_line_rec.operation = Oe_Globals.G_Opr_Update THEN
2947: DECLARE
2948: l_old_arrival_set oe_sets.set_name%TYPE := null;
2949: BEGIN
2950: -- Get existing arrival set.
2951: SELECT set_name
2952: INTO l_old_arrival_set

Line 2953: FROM oe_sets s,

2949: BEGIN
2950: -- Get existing arrival set.
2951: SELECT set_name
2952: INTO l_old_arrival_set
2953: FROM oe_sets s,
2954: oe_order_lines_all l
2955: WHERE s.set_type = 'ARRIVAL_SET'
2956: AND l.arrival_set_id = s.set_id
2957: AND l.line_id = p_x_line_rec.line_id;

Line 3937: -- In case it is non-null, derive its ship_set_id from table: oe_sets;

3933: ELSE
3934: -- Check whether p_x_line_rec.ship_set is not-null;
3935: IF p_x_line_rec.ship_set IS NOT NULL THEN
3936:
3937: -- In case it is non-null, derive its ship_set_id from table: oe_sets;
3938: SELECT DISTINCT set_id INTO l_old_ship_set_id
3939: FROM oe_sets
3940: WHERE set_type = 'SHIP_SET'
3941: AND header_id = p_x_line_rec.header_id

Line 3939: FROM oe_sets

3935: IF p_x_line_rec.ship_set IS NOT NULL THEN
3936:
3937: -- In case it is non-null, derive its ship_set_id from table: oe_sets;
3938: SELECT DISTINCT set_id INTO l_old_ship_set_id
3939: FROM oe_sets
3940: WHERE set_type = 'SHIP_SET'
3941: AND header_id = p_x_line_rec.header_id
3942: AND set_name = p_x_line_rec.ship_set;
3943:

Line 3985: l_old_ship_set oe_sets.set_name%TYPE := null;

3981: -------------------
3982: /*
3983: IF p_x_line_rec.operation = Oe_Globals.G_Opr_Update THEN
3984: DECLARE
3985: l_old_ship_set oe_sets.set_name%TYPE := null;
3986: BEGIN
3987: -- Get existing ship set.
3988: SELECT set_name
3989: INTO l_old_ship_set

Line 3990: FROM oe_sets s,

3986: BEGIN
3987: -- Get existing ship set.
3988: SELECT set_name
3989: INTO l_old_ship_set
3990: FROM oe_sets s,
3991: oe_order_lines_all l
3992: WHERE s.set_type = 'SHIP_SET'
3993: AND l.ship_set_id = s.set_id
3994: AND l.line_id = p_x_line_rec.line_id;