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.RLM_CUM_SV dependencies on OE_ORDER_LINES

Line 23: key table and OE Order Lines.

19: CUSTOMER or ADDRESS, or for the CUSTOMER_ITEM eligible
20: for CUM Calculation.
21:
22: 3) update cum key after shipment. Updates occur in cum
23: key table and OE Order Lines.
24:
25: 4) adjust cum key every time cum start date is altered
26:
27: CLIENT/SERVER: Server

Line 48: inventory_item_id OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,

44: TYPE cum_key_attrib_rec_type IS RECORD (
45: -- Parameter definition is changed as per TCA obsolescence project.
46: customer_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
47: customer_item_id RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
48: inventory_item_id OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
49: ship_from_org_id RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
50: intrmd_ship_to_address_id RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
51: ship_to_address_id RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
52: bill_to_address_id RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,

Line 69: shipped_quantity OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE DEFAULT 0,

65: msg_name VARCHAR2(30) DEFAULT NULL,
66: record_return_status BOOLEAN DEFAULT FALSE,
67: cum_key_id RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
68: cum_start_date RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
69: shipped_quantity OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE DEFAULT 0,
70: actual_shipment_date OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE DEFAULT SYSDATE,
71: cum_key_created_flag BOOLEAN DEFAULT FALSE,
72: cum_qty RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE DEFAULT 0,
73: as_of_date_cum_qty RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE DEFAULT 0,

Line 70: actual_shipment_date OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE DEFAULT SYSDATE,

66: record_return_status BOOLEAN DEFAULT FALSE,
67: cum_key_id RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
68: cum_start_date RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
69: shipped_quantity OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE DEFAULT 0,
70: actual_shipment_date OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE DEFAULT SYSDATE,
71: cum_key_created_flag BOOLEAN DEFAULT FALSE,
72: cum_qty RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE DEFAULT 0,
73: as_of_date_cum_qty RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE DEFAULT 0,
74: cum_qty_to_be_accumulated RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE DEFAULT 0,

Line 82: as_of_date_time OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,

78: use_ship_incl_rule_flag VARCHAR2(1) DEFAULT 'Y',
79: shipment_rule_code RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE DEFAULT 'AS_OF_CURRENT',
80: yesterday_time_cutoff RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
81: last_update_date RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
82: as_of_date_time OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
83: customer_item_id RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
84: inventory_item_id OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE);
85:
86: TYPE cum_oe_lines_type IS RECORD (

Line 84: inventory_item_id OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE);

80: yesterday_time_cutoff RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
81: last_update_date RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
82: as_of_date_time OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
83: customer_item_id RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
84: inventory_item_id OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE);
85:
86: TYPE cum_oe_lines_type IS RECORD (
87: line_id oe_order_lines.line_id%TYPE,
88: header_id oe_order_lines.header_id%TYPE,

Line 87: line_id oe_order_lines.line_id%TYPE,

83: customer_item_id RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
84: inventory_item_id OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE);
85:
86: TYPE cum_oe_lines_type IS RECORD (
87: line_id oe_order_lines.line_id%TYPE,
88: header_id oe_order_lines.header_id%TYPE,
89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,

Line 88: header_id oe_order_lines.header_id%TYPE,

84: inventory_item_id OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE);
85:
86: TYPE cum_oe_lines_type IS RECORD (
87: line_id oe_order_lines.line_id%TYPE,
88: header_id oe_order_lines.header_id%TYPE,
89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,
92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,

Line 89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,

85:
86: TYPE cum_oe_lines_type IS RECORD (
87: line_id oe_order_lines.line_id%TYPE,
88: header_id oe_order_lines.header_id%TYPE,
89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,
92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,
93: order_quantity_uom oe_order_lines.order_quantity_uom%TYPE,

Line 90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,

86: TYPE cum_oe_lines_type IS RECORD (
87: line_id oe_order_lines.line_id%TYPE,
88: header_id oe_order_lines.header_id%TYPE,
89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,
92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,
93: order_quantity_uom oe_order_lines.order_quantity_uom%TYPE,
94: org_id oe_order_lines_all.org_id%TYPE);

Line 91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,

87: line_id oe_order_lines.line_id%TYPE,
88: header_id oe_order_lines.header_id%TYPE,
89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,
92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,
93: order_quantity_uom oe_order_lines.order_quantity_uom%TYPE,
94: org_id oe_order_lines_all.org_id%TYPE);
95:

Line 92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,

88: header_id oe_order_lines.header_id%TYPE,
89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,
92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,
93: order_quantity_uom oe_order_lines.order_quantity_uom%TYPE,
94: org_id oe_order_lines_all.org_id%TYPE);
95:
96:

Line 93: order_quantity_uom oe_order_lines.order_quantity_uom%TYPE,

89: --industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,
92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,
93: order_quantity_uom oe_order_lines.order_quantity_uom%TYPE,
94: org_id oe_order_lines_all.org_id%TYPE);
95:
96:
97: TYPE t_oe_header_rec IS RECORD (

Line 94: org_id oe_order_lines_all.org_id%TYPE);

90: --industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
91: shipped_quantity oe_order_lines.shipped_quantity%TYPE,
92: actual_shipment_date oe_order_lines.actual_shipment_date%TYPE,
93: order_quantity_uom oe_order_lines.order_quantity_uom%TYPE,
94: org_id oe_order_lines_all.org_id%TYPE);
95:
96:
97: TYPE t_oe_header_rec IS RECORD (
98: header_id NUMBER,

Line 215: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,

211: x_msg_data IN OUT NOCOPY VARCHAR2,
212: x_record_return_status IN OUT NOCOPY BOOLEAN,
213: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
214: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
215: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
216: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
217: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
218: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
219: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

Line 216: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,

212: x_record_return_status IN OUT NOCOPY BOOLEAN,
213: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
214: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
215: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
216: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
217: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
218: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
219: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
220: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,

Line 228: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE);

224: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
225: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
226: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
227: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
228: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE);
229:
230: /*=============================================================================
231: PROCEDURE NAME: CalculateSupplierCum
232:

Line 271: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,

267: PROCEDURE CalculateSupplierCumClient (
268: -- Parameter definition is changed as per TCA obsolescence project.
269: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
270: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
271: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
272: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
273: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
274: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
275: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,

Line 283: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,

279: x_msg_data IN OUT NOCOPY VARCHAR2,
280: x_record_return_status IN OUT NOCOPY BOOLEAN,
281: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
282: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
283: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
284: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
285: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
286: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
287: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

Line 284: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,

280: x_record_return_status IN OUT NOCOPY BOOLEAN,
281: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
282: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
283: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
284: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
285: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
286: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
287: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
288: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,

Line 296: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE);

292: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
293: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
294: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
295: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
296: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE);
297:
298: /*=============================================================================
299: PROCEDURE NAME: UpdateCumKey
300:

Line 302: the cum key id and attach it to the OE Order Lines

298: /*=============================================================================
299: PROCEDURE NAME: UpdateCumKey
300:
301: DESCRIPTION: This procedure will be called to calculate
302: the cum key id and attach it to the OE Order Lines
303: after shipment has been confirmed.
304: It is also called to calculate the total cum
305: quantities including the shipment quantities that
306: are just confirmed.

Line 322: the cum key id and attach it to the OE Order Lines

318: /*=============================================================================
319: PROCEDURE NAME: UpdateCumKeyClient
320:
321: DESCRIPTION: This procedure will be called to calculate
322: the cum key id and attach it to the OE Order Lines
323: after shipment has been confirmed.
324: It is also called to calculate the total cum
325: quantities including the shipment quantities that
326: are just confirmed.