DBA Data[Home] [Help]

APPS.RLM_RD_SV dependencies on OE_ORDER_LINES

Line 115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,

111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
113: schedule_date rlm_interface_lines.schedule_date%TYPE,
114: uom_code rlm_interface_lines.uom_code%TYPE,
115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
116: shipment_flag VARCHAR2(30),
117: item_identifier_type VARCHAR2(25),
118: process_status rlm_interface_lines.process_status%TYPE,
119: cust_po_line_num rlm_interface_lines.cust_po_line_num%TYPE,

Line 323: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,

319: --
320: TYPE t_OEDemand_rec IS RECORD (
321: header_id NUMBER,
322: line_id NUMBER,
323: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
324: ship_to_org_id oe_order_lines.ship_to_org_id%TYPE,
325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,
326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,

Line 324: ship_to_org_id oe_order_lines.ship_to_org_id%TYPE,

320: TYPE t_OEDemand_rec IS RECORD (
321: header_id NUMBER,
322: line_id NUMBER,
323: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
324: ship_to_org_id oe_order_lines.ship_to_org_id%TYPE,
325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,
326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,

Line 325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,

321: header_id NUMBER,
322: line_id NUMBER,
323: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
324: ship_to_org_id oe_order_lines.ship_to_org_id%TYPE,
325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,
326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,

Line 326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,

322: line_id NUMBER,
323: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
324: ship_to_org_id oe_order_lines.ship_to_org_id%TYPE,
325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,
326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,

Line 327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,

323: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
324: ship_to_org_id oe_order_lines.ship_to_org_id%TYPE,
325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,
326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,

Line 328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,

324: ship_to_org_id oe_order_lines.ship_to_org_id%TYPE,
325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,
326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,

Line 329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,

325: ordered_item_id oe_order_lines.ordered_item_id%TYPE,
326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,

Line 330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,

326: inventory_item_id oe_order_lines.inventory_item_id%TYPE,
327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,

Line 331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,

327: invoice_to_org_id oe_order_lines.invoice_to_org_id%TYPE,
328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,

Line 332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,

328: intmed_ship_to_org_id oe_order_lines.intmed_ship_to_org_id%TYPE,
329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,

Line 333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,

329: demand_bucket_type_code oe_order_lines.demand_bucket_type_code%TYPE,
330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,

Line 334: ordered_item oe_order_lines.ordered_item%TYPE,

330: rla_schedule_type_code oe_order_lines.rla_schedule_type_code%TYPE,
331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,

Line 335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,

331: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,

Line 336: item_type_code oe_order_lines.item_type_code%TYPE,

332: orig_ordered_quantity oe_order_lines.ordered_quantity%TYPE,
333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,

Line 337: blanket_number oe_order_lines.blanket_number%TYPE,

333: ordered_quantity oe_order_lines.ordered_quantity%TYPE,
334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,

Line 338: customer_line_number oe_order_lines.customer_line_number%TYPE,

334: ordered_item oe_order_lines.ordered_item%TYPE,
335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,

Line 339: cust_production_line oe_order_lines.customer_production_line%TYPE,

335: item_identifier_type oe_order_lines.item_identifier_type%TYPE,
336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,

Line 340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,

336: item_type_code oe_order_lines.item_type_code%TYPE,
337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,

Line 341: request_date oe_order_lines.request_date%TYPE,

337: blanket_number oe_order_lines.blanket_number%TYPE,
338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,

Line 342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,

338: customer_line_number oe_order_lines.customer_line_number%TYPE,
339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,

Line 343: cust_po_number oe_order_lines.cust_po_number%TYPE,

339: cust_production_line oe_order_lines.customer_production_line%TYPE,
340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,

Line 344: customer_item_revision oe_order_lines.item_revision%TYPE,

340: customer_dock_code oe_order_lines.customer_dock_code%TYPE,
341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,

Line 345: customer_job oe_order_lines.customer_job%TYPE,

341: request_date oe_order_lines.request_date%TYPE,
342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,

Line 346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,

342: schedule_ship_date oe_order_lines.schedule_ship_date%TYPE,
343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,

Line 347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,

343: cust_po_number oe_order_lines.cust_po_number%TYPE,
344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,

Line 348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,

344: customer_item_revision oe_order_lines.item_revision%TYPE,
345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,

Line 349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,

345: customer_job oe_order_lines.customer_job%TYPE,
346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,

Line 350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,

346: cust_model_serial_number oe_order_lines.cust_model_serial_number%TYPE,
347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,

Line 351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,

347: cust_production_seq_num oe_order_lines.cust_production_seq_num%TYPE,
348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,

Line 352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,

348: industry_attribute1 oe_order_lines.industry_attribute1%TYPE,
349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,

Line 353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,

349: industry_attribute2 oe_order_lines.industry_attribute2%TYPE,
350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,

Line 354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,

350: industry_attribute3 oe_order_lines.industry_attribute3%TYPE,
351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,

Line 355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,

351: industry_attribute4 oe_order_lines.industry_attribute4%TYPE,
352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,

Line 356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,

352: industry_attribute5 oe_order_lines.industry_attribute5%TYPE,
353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,

Line 357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,

353: industry_attribute6 oe_order_lines.industry_attribute6%TYPE,
354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,

Line 358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,

354: industry_attribute7 oe_order_lines.industry_attribute7%TYPE,
355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,

Line 359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,

355: industry_attribute8 oe_order_lines.industry_attribute8%TYPE,
356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,

Line 360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,

356: industry_attribute9 oe_order_lines.industry_attribute9%TYPE,
357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,

Line 361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,

357: industry_attribute10 oe_order_lines.industry_attribute10%TYPE,
358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,

Line 362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,

358: industry_attribute11 oe_order_lines.industry_attribute11%TYPE,
359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,

Line 363: attribute1 oe_order_lines.attribute1%TYPE,

359: industry_attribute12 oe_order_lines.industry_attribute12%TYPE,
360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,

Line 364: attribute2 oe_order_lines.attribute2%TYPE,

360: industry_attribute13 oe_order_lines.industry_attribute13%TYPE,
361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,

Line 365: attribute3 oe_order_lines.attribute3%TYPE,

361: industry_attribute14 oe_order_lines.industry_attribute14%TYPE,
362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,

Line 366: attribute4 oe_order_lines.attribute4%TYPE,

362: industry_attribute15 oe_order_lines.industry_attribute15%TYPE,
363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,

Line 367: attribute5 oe_order_lines.attribute5%TYPE,

363: attribute1 oe_order_lines.attribute1%TYPE,
364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,

Line 368: attribute6 oe_order_lines.attribute6%TYPE,

364: attribute2 oe_order_lines.attribute2%TYPE,
365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,

Line 369: attribute7 oe_order_lines.attribute7%TYPE,

365: attribute3 oe_order_lines.attribute3%TYPE,
366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,

Line 370: attribute8 oe_order_lines.attribute8%TYPE,

366: attribute4 oe_order_lines.attribute4%TYPE,
367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,

Line 371: attribute9 oe_order_lines.attribute9%TYPE,

367: attribute5 oe_order_lines.attribute5%TYPE,
368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,

Line 372: attribute10 oe_order_lines.attribute10%TYPE,

368: attribute6 oe_order_lines.attribute6%TYPE,
369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,
376: attribute14 oe_order_lines.attribute14%TYPE,

Line 373: attribute11 oe_order_lines.attribute11%TYPE,

369: attribute7 oe_order_lines.attribute7%TYPE,
370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,
376: attribute14 oe_order_lines.attribute14%TYPE,
377: attribute15 oe_order_lines.attribute15%TYPE,

Line 374: attribute12 oe_order_lines.attribute12%TYPE,

370: attribute8 oe_order_lines.attribute8%TYPE,
371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,
376: attribute14 oe_order_lines.attribute14%TYPE,
377: attribute15 oe_order_lines.attribute15%TYPE,
378: end_date_time oe_order_lines.request_date%TYPE,

Line 375: attribute13 oe_order_lines.attribute13%TYPE,

371: attribute9 oe_order_lines.attribute9%TYPE,
372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,
376: attribute14 oe_order_lines.attribute14%TYPE,
377: attribute15 oe_order_lines.attribute15%TYPE,
378: end_date_time oe_order_lines.request_date%TYPE,
379: schedule_hierarchy VARCHAR2(30)

Line 376: attribute14 oe_order_lines.attribute14%TYPE,

372: attribute10 oe_order_lines.attribute10%TYPE,
373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,
376: attribute14 oe_order_lines.attribute14%TYPE,
377: attribute15 oe_order_lines.attribute15%TYPE,
378: end_date_time oe_order_lines.request_date%TYPE,
379: schedule_hierarchy VARCHAR2(30)
380: );

Line 377: attribute15 oe_order_lines.attribute15%TYPE,

373: attribute11 oe_order_lines.attribute11%TYPE,
374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,
376: attribute14 oe_order_lines.attribute14%TYPE,
377: attribute15 oe_order_lines.attribute15%TYPE,
378: end_date_time oe_order_lines.request_date%TYPE,
379: schedule_hierarchy VARCHAR2(30)
380: );
381:

Line 378: end_date_time oe_order_lines.request_date%TYPE,

374: attribute12 oe_order_lines.attribute12%TYPE,
375: attribute13 oe_order_lines.attribute13%TYPE,
376: attribute14 oe_order_lines.attribute14%TYPE,
377: attribute15 oe_order_lines.attribute15%TYPE,
378: end_date_time oe_order_lines.request_date%TYPE,
379: schedule_hierarchy VARCHAR2(30)
380: );
381:
382: -- Bug 4351397

Line 1876: oe_order_lines.

1872: /*===========================================================================
1873: PROCEDURE NAME: GetDemand
1874:
1875: DESCRIPTION: This procedure will retrieve demand attributes from
1876: oe_order_lines.
1877:
1878: PARAMETERS: x_Key_rec IN OUT NOCOPY t_Key_rec
1879:
1880: DESIGN REFERENCES: RLADPRDD.rtf