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.CSP_SCH_INT_PVT dependencies on OE_ORDER_LINES_ALL

Line 347: oe_order_lines_all oola

343: into l_partial_line
344: FROM csp_requirement_headers h,
345: csp_requirement_lines l,
346: csp_req_line_details d,
347: oe_order_lines_all oola
348: WHERE h.task_id = p_task_id
349: AND h.task_assignment_id = r_asgn.task_assignment_id
350: AND h.requirement_header_id = l.requirement_header_id
351: AND l.requirement_line_id = d.requirement_line_id

Line 382: oe_order_lines_all oola,

378: FROM csp_requirement_headers h,
379: csp_requirement_lines l,
380: csp_req_line_details dio,
381: csp_req_line_details dres,
382: oe_order_lines_all oola,
383: mtl_reservations mr
384: WHERE h.task_id = p_task_id
385: AND h.task_assignment_id = r_asgn.task_assignment_id
386: AND h.address_type IN ('R', 'S')

Line 410: oe_order_lines_all oola,

406: into l_order_number
407: FROM csp_requirement_headers h,
408: csp_requirement_lines l,
409: csp_req_line_details dio,
410: oe_order_lines_all oola,
411: oe_order_headers_all ooha
412: WHERE h.task_id = p_task_id
413: AND h.task_assignment_id = r_asgn.task_assignment_id
414: AND h.address_type IN ('R', 'S')

Line 440: oe_order_lines_all oola,

436: FROM csp_requirement_headers h,
437: csp_requirement_lines l,
438: csp_req_line_details dio,
439: csp_req_line_details dres,
440: oe_order_lines_all oola,
441: mtl_reservations mr
442: WHERE h.task_id = p_task_id
443: AND h.task_assignment_id = r_asgn.task_assignment_id
444: AND h.address_type IN ('T', 'C', 'P')

Line 473: oe_order_lines_all oola,

469: csp_requirement_lines l,
470: csp_req_line_details dio,
471: csp_req_line_details dres,
472: csp_req_line_details dother,
473: oe_order_lines_all oola,
474: mtl_reservations mr
475: WHERE h.task_id = p_task_id
476: AND h.task_assignment_id = r_asgn.task_assignment_id
477: AND h.address_type IN ('T', 'C', 'P')

Line 528: oe_order_lines_all oola,

524: FROM csp_requirement_headers h,
525: csp_requirement_lines l,
526: csp_req_line_details dio,
527: csp_req_line_details dres,
528: oe_order_lines_all oola,
529: mtl_reservations mr
530: WHERE h.task_id = p_task_id
531: AND h.task_assignment_id = r_asgn.task_assignment_id
532: AND h.address_type IN ('T', 'C', 'P')

Line 582: oe_order_lines_all oola,

578: FROM csp_requirement_headers h,
579: csp_requirement_lines l,
580: csp_req_line_details dio,
581: csp_req_line_details dres,
582: oe_order_lines_all oola,
583: mtl_reservations mr
584: WHERE h.task_id = p_task_id
585: AND h.task_assignment_id = r_asgn.task_assignment_id
586: AND h.address_type IN ('T', 'C', 'P')

Line 633: oe_order_lines_all oola

629: into l_shpd_lines
630: FROM csp_requirement_headers h,
631: csp_requirement_lines l,
632: csp_req_line_details d,
633: oe_order_lines_all oola
634: WHERE h.task_id = p_task_id
635: AND h.task_assignment_id = r_asgn.task_assignment_id
636: AND h.requirement_header_id = l.requirement_header_id
637: AND l.requirement_line_id = d.requirement_line_id

Line 669: oe_order_lines_all oola,

665: INTO l_order_number
666: FROM csp_requirement_headers h,
667: csp_requirement_lines l,
668: csp_req_line_details d,
669: oe_order_lines_all oola,
670: oe_order_headers_all ooha
671: WHERE h.task_assignment_id = r_asgn.task_assignment_id
672: AND h.task_id = p_task_id
673: AND h.requirement_header_id = l.requirement_header_id

Line 698: oe_order_lines_all oola

694: FROM csp_requirement_headers h,
695: csp_requirement_lines l,
696: csp_req_line_details d,
697: csp_req_line_details dother,
698: oe_order_lines_all oola
699: WHERE h.task_id = p_task_id
700: AND h.task_assignment_id = r_asgn.task_assignment_id
701: AND h.requirement_header_id = l.requirement_header_id
702: AND l.requirement_line_id = d.requirement_line_id

Line 744: oe_order_lines_all oola

740: SELECT l.requirement_line_id
741: FROM csp_requirement_headers h,
742: csp_requirement_lines l,
743: csp_req_line_details d,
744: oe_order_lines_all oola
745: WHERE h.task_id = p_task_id
746: AND h.task_assignment_id = r_asgn.task_assignment_id
747: AND h.requirement_header_id = l.requirement_header_id
748: AND l.requirement_line_id = d.requirement_line_id

Line 789: oe_order_lines_all oola

785: SELECT l.requirement_line_id
786: FROM csp_requirement_headers h,
787: csp_requirement_lines l,
788: csp_req_line_details d,
789: oe_order_lines_all oola
790: WHERE h.task_id = p_task_id
791: AND h.task_assignment_id = r_asgn.task_assignment_id
792: AND h.requirement_header_id = l.requirement_header_id
793: AND l.requirement_line_id = d.requirement_line_id

Line 812: oe_order_lines_all oel

808: into l_old_arrival_date
809: FROM csp_requirement_headers h,
810: csp_requirement_lines l,
811: csp_req_line_details d,
812: oe_order_lines_all oel
813: WHERE h.task_id = p_task_id
814: AND h.task_assignment_id = r_asgn.task_assignment_id
815: AND h.requirement_header_id = l.requirement_header_id
816: AND l.requirement_line_id = d.requirement_line_id

Line 898: oe_order_lines_all oel

894: into l_old_arrival_date
895: FROM csp_requirement_headers h,
896: csp_requirement_lines l,
897: csp_req_line_details d,
898: oe_order_lines_all oel
899: WHERE h.task_id = p_task_id
900: AND h.task_assignment_id = r_asgn.task_assignment_id
901: AND h.requirement_header_id = l.requirement_header_id
902: AND l.requirement_line_id = d.requirement_line_id

Line 1396: oe_order_lines_all oola,

1392: FROM csp_requirement_headers h,
1393: csp_requirement_lines l,
1394: csp_req_line_details dio,
1395: csp_req_line_details dres,
1396: oe_order_lines_all oola,
1397: mtl_reservations mr
1398: WHERE h.task_id = p_task_id
1399: AND h.task_assignment_id = r_asgn.task_assignment_id
1400: AND h.address_type IN ('T', 'C', 'P')

Line 1448: oe_order_lines_all oola

1444: into l_shpd_lines
1445: FROM csp_requirement_headers h,
1446: csp_requirement_lines l,
1447: csp_req_line_details d,
1448: oe_order_lines_all oola
1449: WHERE h.task_id = p_task_id
1450: AND h.task_assignment_id = r_asgn.task_assignment_id
1451: AND h.requirement_header_id = l.requirement_header_id
1452: and h.address_type in ('C', 'T', 'P')

Line 2236: from oe_order_lines_all oel, oe_order_headers_all oeh, csp_requirement_headers crh, csp_requirement_lines crl

2232: AND crl.local_RESERVATION_ID IS NOT NULL;
2233:
2234: cursor cancel_order IS
2235: select distinct oeh.header_id,crl.requirement_line_id
2236: from oe_order_lines_all oel, oe_order_headers_all oeh, csp_requirement_headers crh, csp_requirement_lines crl
2237: where crh.task_assignment_id = p_task_assignment_id
2238: and crl.REQUIREMENT_HEADER_ID = crh.REQUIREMENT_HEADER_ID
2239: and oel.line_id = crl.order_line_id
2240: and oeh.header_id = oel.header_id

Line 2449: ,oe_order_lines_all oel

2445: select oeh.header_id, crld.req_line_detail_id, crh.address_type
2446: from csp_req_line_details crld
2447: ,csp_requirement_lines crl
2448: ,csp_requirement_headers crh
2449: ,oe_order_lines_all oel
2450: ,oe_order_headers_all oeh
2451: where crh.task_assignment_id = p_task_assignment_id
2452: and crl.requirement_header_id = crh.requirement_header_id
2453: and crld.requirement_line_id = crl.requirement_line_id

Line 2466: from csp_req_line_details crld,oe_order_lines_all oel

2462: where header_id = c_header_id;
2463:
2464: cursor get_line_details(c_order_header_id Number) is
2465: select REQ_LINE_DETAIL_ID
2466: from csp_req_line_details crld,oe_order_lines_all oel
2467: where crld.source_id = oel.line_id
2468: and crld.source_type = 'IO'
2469: and oel.header_id = c_order_header_id;
2470:

Line 2502: oe_order_lines_all oola,

2498: FROM csp_requirement_headers h,
2499: csp_requirement_lines l,
2500: csp_req_line_details dio,
2501: csp_req_line_details dres,
2502: oe_order_lines_all oola,
2503: mtl_reservations mr
2504: WHERE h.task_assignment_id = p_task_assignment_id
2505: AND h.address_type IN ('T', 'C', 'P')
2506: AND h.requirement_header_id = l.requirement_header_id

Line 2533: oe_order_lines_all oola

2529: into l_shpd_lines
2530: FROM csp_requirement_headers h,
2531: csp_requirement_lines l,
2532: csp_req_line_details d,
2533: oe_order_lines_all oola
2534: WHERE h.task_assignment_id = p_task_assignment_id
2535: AND h.requirement_header_id = l.requirement_header_id
2536: and h.address_type in ('C', 'T', 'P')
2537: AND l.requirement_line_id = d.requirement_line_id

Line 2617: FROM oe_order_lines_all

2613: end if;
2614:
2615: SELECT COUNT(1)
2616: INTO l_line_to_cancel
2617: FROM oe_order_lines_all
2618: WHERE header_id = l_order_id
2619: AND cancelled_flag = 'N'
2620: AND open_flag = 'Y'
2621: AND flow_status_code <> 'SHIPPED';

Line 2818: ,oe_order_lines_all oel

2814: select distinct oeh.header_id, oel.line_id
2815: from csp_req_line_details crld
2816: ,csp_requirement_lines crl
2817: ,csp_requirement_headers crh
2818: ,oe_order_lines_all oel
2819: ,oe_order_headers_all oeh
2820: where crh.task_assignment_id = p_task_assignment_id
2821: and crl.requirement_header_id = crh.requirement_header_id
2822: and crld.requirement_line_id = crl.requirement_line_id

Line 8064: ,oe_order_lines_all oel

8060: select oeh.header_id, crld.req_line_detail_id
8061: from csp_req_line_details crld
8062: ,csp_requirement_lines crl
8063: ,csp_requirement_headers crh
8064: ,oe_order_lines_all oel
8065: ,oe_order_headers_all oeh
8066: where crh.task_id = l_task_id
8067: and crl.requirement_header_id = crh.requirement_header_id
8068: and crld.requirement_line_id = crl.requirement_line_id

Line 8087: from csp_req_line_details crld,oe_order_lines_all oel

8083: and ( CANCELLED_FLAG = 'Y' or rejected_flag = 'Y');
8084:
8085: cursor get_line_details(c_order_header_id Number) is
8086: select REQ_LINE_DETAIL_ID
8087: from csp_req_line_details crld,oe_order_lines_all oel
8088: where crld.source_id = oel.line_id
8089: and crld.source_type = 'IO'
8090: and oel.header_id = c_order_header_id;
8091:

Line 8150: oe_order_lines_all oola,csp_req_line_details crld,

8146: crld.requirement_line_id requirement_line_id,rcl.quantity_shipped quantity_shipped,
8147: rcl.quantity_received quantity_received,crld.req_line_detail_id req_line_detail_id
8148: from mtl_material_transactions mmt,RCV_SHIPMENT_headers rsh,
8149: rcv_shipment_lines rcl,
8150: oe_order_lines_all oola,csp_req_line_details crld,
8151: csp_requirement_lines crl,
8152: csp_requirement_headers crh
8153: where mmt.transaction_id = p_transaction_id
8154: and mmt.shipment_number = rsh.shipment_num

Line 8170: oe_order_lines_all oola,csp_req_line_details crld,

8166: crld.source_id line_id, mmt.transaction_uom uom,crh.need_by_date need_by_date,
8167: crld.requirement_line_id requirement_line_id, mmt.transaction_quantity quantity_shipped,
8168: mmt.transaction_quantity quantity_received,crld.req_line_detail_id req_line_detail_id
8169: from mtl_material_transactions mmt,
8170: oe_order_lines_all oola,csp_req_line_details crld,
8171: csp_requirement_lines crl,csp_requirement_headers crh
8172: where mmt.transaction_id = p_transaction_id
8173: and oola.source_document_id = mmt.transaction_source_id
8174: and crld.source_id = oola.line_id

Line 8370: oe_order_lines_all oola,

8366: FROM csp_requirement_headers h,
8367: csp_requirement_lines l,
8368: csp_req_line_details dio,
8369: csp_req_line_details dres,
8370: oe_order_lines_all oola,
8371: mtl_reservations mr
8372: WHERE h.task_id = p_task_id
8373: AND h.task_assignment_id = p_task_asgn_id
8374: AND h.address_type IN ('T', 'C', 'P')