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 CSP_REQUIREMENT_LINES

Line 224: from csp_requirement_lines crl,csp_requirement_headers crh

220: l_temp_line_id NUMBER;
221:
222: cursor get_line_id is
223: select distinct(crl.requirement_line_id) req_line_id
224: from csp_requirement_lines crl,csp_requirement_headers crh
225: where crh.task_id = p_task_id
226: and crl.requirement_header_id = crh.requirement_header_id;
227: BEGIN
228:

Line 381: -- l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;

377: min_cost NUMBER ;
378: l_final_option CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE ;
379: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
380: l_org_ship_methode org_ship_methodes_tbl_type ;
381: -- l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
382: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE;
383: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
384: l_parts_header csp_parts_requirement.Header_rec_type;
385: l_parts_lines csp_parts_requirement.Line_Tbl_type;

Line 626: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;

622: , p_data => x_msg_data);
623: return;
624: END IF;
625: l_req_line_details_tbl.extend;
626: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
627: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
628: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'RES' ;
629: l_req_line_details_tbl(l_req_line_details_tbl.count).source_id := l_reservation_id ;
630: ELSE

Line 647: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;

643: l_parts_lines(rec_count).reservation_id := l_reservation_id;
644: l_parts_lines(rec_count).requirement_line_id := l_requirements_line_id;
645: rec_count := rec_count + 1;
646: l_req_line_details_tbl.extend;
647: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
648: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
649: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'IO' ;
650: END IF;
651: END LOOP;

Line 687: /* CSP_Requirement_Lines_PVT.Update_requirement_lines(

683: EXIT;
684: END IF;
685: END LOOP;
686: END LOOP;
687: /* CSP_Requirement_Lines_PVT.Update_requirement_lines(
688: P_Api_Version_Number => 1.0,
689: P_Init_Msg_List => FND_API.G_FALSE,
690: P_Commit => FND_API.G_FALSE,
691: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 760: FROM CSP_REQUIREMENT_LINES crl, csp_requirement_headers crh

756: ,x_msg_count OUT NOCOPY NUMBER) IS
757:
758: CURSOR cancel_reserv IS
759: SELECT crl.RESERVATION_ID,crl.LOCAL_RESERVATION_ID,crl.REQUIREMENT_LINE_ID
760: FROM CSP_REQUIREMENT_LINES crl, csp_requirement_headers crh
761: WHERE crh.task_assignment_id = p_task_assignment_id
762: and crl.REQUIREMENT_HEADER_ID = crh.requirement_header_id
763: AND crl.local_RESERVATION_ID IS NOT NULL;
764:

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

763: AND crl.local_RESERVATION_ID IS NOT NULL;
764:
765: cursor cancel_order IS
766: select distinct oeh.header_id,crl.requirement_line_id
767: from oe_order_lines_all oel, oe_order_headers_all oeh, csp_requirement_headers crh, csp_requirement_lines crl
768: where crh.task_assignment_id = p_task_assignment_id
769: and crl.REQUIREMENT_HEADER_ID = crh.REQUIREMENT_HEADER_ID
770: and oel.line_id = crl.order_line_id
771: and oeh.header_id = oel.header_id

Line 784: l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;

780: l_msg_count NUMBER;
781: l_order_line_id NUMBER;
782: l_previous_order_id NUMBER := 0;
783: l_requirement_line_id NUMBER;
784: l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
785: l_Requirement_Line_Tbl_order CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
786: req_loop NUMBER := 0 ;
787: reservation_present BOOLEAN := FALSE;
788: order_present BOOLEAN := FALSE;

Line 785: l_Requirement_Line_Tbl_order CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;

781: l_order_line_id NUMBER;
782: l_previous_order_id NUMBER := 0;
783: l_requirement_line_id NUMBER;
784: l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
785: l_Requirement_Line_Tbl_order CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
786: req_loop NUMBER := 0 ;
787: reservation_present BOOLEAN := FALSE;
788: order_present BOOLEAN := FALSE;
789: BEGIN

Line 829: CSP_Requirement_Lines_PVT.Update_requirement_lines(

825: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
826: return;
827: ELSE
828: IF reservation_present THEN
829: CSP_Requirement_Lines_PVT.Update_requirement_lines(
830: P_Api_Version_Number => 1.0,
831: P_Init_Msg_List => FND_API.G_FALSE,
832: P_Commit => FND_API.G_FALSE,
833: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 885: CSP_Requirement_Lines_PVT.Update_requirement_lines(

881: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
882: return;
883: ELSE
884: IF order_present then
885: CSP_Requirement_Lines_PVT.Update_requirement_lines(
886: P_Api_Version_Number => 1.0,
887: P_Init_Msg_List => FND_API.G_FALSE,
888: P_Commit => FND_API.G_FALSE,
889: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 931: ,csp_requirement_lines crl

927:
928: CURSOR get_reservations is
929: select crld.source_id , crld.req_line_detail_id
930: from csp_req_line_details crld
931: ,csp_requirement_lines crl
932: ,csp_requirement_headers crh
933: where crh.task_assignment_id = p_task_assignment_id
934: and crl.requirement_header_id = crh.requirement_header_id
935: and crld.requirement_line_id = crl.requirement_line_id

Line 941: ,csp_requirement_lines crl

937:
938: CURSOR get_orders is
939: select oeh.header_id, crld.req_line_detail_id
940: from csp_req_line_details crld
941: ,csp_requirement_lines crl
942: ,csp_requirement_headers crh
943: ,oe_order_lines_all oel
944: ,oe_order_headers_all oeh
945: where crh.task_assignment_id = p_task_assignment_id

Line 1129: ,csp_requirement_lines crl

1125:
1126: CURSOR get_orders is
1127: select distinct oeh.header_id, oel.line_id
1128: from csp_req_line_details crld
1129: ,csp_requirement_lines crl
1130: ,csp_requirement_headers crh
1131: ,oe_order_lines_all oel
1132: ,oe_order_headers_all oeh
1133: where crh.task_assignment_id = p_task_assignment_id

Line 1204: FROM CSP_REQUIREMENT_HEADERS HR,CSP_REQUIREMENT_LINES LN

1200: /* CURSOR get_parts(c_task_assignment NUMBER) IS
1201: SELECT INVENTORY_ITEM_ID, UOM_CODE,REVISION
1202: ,SHIP_COMPLETE_FLAG,SOURCE_ORGANIZATION_ID
1203: ,ORDERED_QUANTITY,REQUIREMENT_LINE_ID,RESERVATION_ID
1204: FROM CSP_REQUIREMENT_HEADERS HR,CSP_REQUIREMENT_LINES LN
1205: WHERE HR.TASK_ASSIGNMENT_ID = c_task_assignment
1206: AND LN.REQUIREMENT_HEADER_ID = HR.REQUIREMENT_HEADER_ID;
1207:
1208:

Line 1222: FROM CSP_REQUIREMENT_LINES

1218: CURSOR C2(c_header_id number) is
1219: SELECT INVENTORY_ITEM_ID, UOM_CODE,REVISION
1220: ,SHIP_COMPLETE_FLAG,SOURCE_ORGANIZATION_ID
1221: ,ORDERED_QUANTITY,REQUIREMENT_LINE_ID,RESERVATION_ID
1222: FROM CSP_REQUIREMENT_LINES
1223: WHERE REQUIREMENT_HEADER_ID = c_header_id;
1224:
1225:
1226: CURSOR get_resource(c_task_assignment_id NUMBER) IS

Line 1248: l_requrements_lines CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;

1244:
1245: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
1246: l_parts_header csp_parts_requirement.Header_rec_type;
1247: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1248: l_requrements_lines CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
1249: l_return_status VARCHAR2(30);
1250: l_msg_count NUMBER;
1251: l_msg_data VARCHAR2(1000);
1252: l_resource_id NUMBER;

Line 1395: CSP_Requirement_Lines_PVT.Update_requirement_lines(

1391: ELSE
1392: l_requrements_lines(I).reservation_id := x_reservation_id;
1393: END IF;
1394: END LOOP;
1395: CSP_Requirement_Lines_PVT.Update_requirement_lines(
1396: P_Api_Version_Number => 1.0,
1397: P_Init_Msg_List => FND_API.G_FALSE,
1398: P_Commit => FND_API.G_FALSE,
1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1504: FROM CSP_REQUIREMENT_LINES crl, CSP_REQUIREMENT_HEADERS crh

1500: ,x_msg_count OUT NOCOPY NUMBER) IS
1501:
1502: CURSOR parts_list(product_task NUMBER, parts_category NUMBER) IS
1503: SELECT INVENTORY_ITEM_ID,REQUIRED_QUANTITY , UOM_CODE,SHIP_COMPLETE_FLAG,REVISION,REQUIREMENT_LINE_ID
1504: FROM CSP_REQUIREMENT_LINES crl, CSP_REQUIREMENT_HEADERS crh
1505: WHERE crh.TASK_ID = product_task
1506: AND crl.requirement_header_id = crh.requirement_header_id
1507: AND nvl(crl.LIKELIHOOD,0) >= nvl(parts_category,0) ;
1508:

Line 1562: FROM CSP_REQUIREMENT_LINES

1558: ,x_msg_count OUT NOCOPY NUMBER) IS
1559: /* CURSOR reservation_check(org_id NUMBER, sub_inv_code VARCHAR2,item_id NUMBER)
1560: IS
1561: SELECT NVL((REQUIRED_QUANTITY-ORDERED_QUANTITY),0)
1562: FROM CSP_REQUIREMENT_LINES
1563: WHERE REQUIREMENT_HEADER_ID = (SELECT REQUIREMENT_HEADER_ID
1564: FROM CSP_REQUIREMENT_HEADERS
1565: WHERE OPEN_REQUIREMENT = 'Yes'
1566: AND DESTINATION_ORGANIZATION_ID = org_id)

Line 4458: FROM CSP_REQUIREMENT_LINES

4454: ,x_msg_count OUT NOCOPY NUMBER) IS
4455: /*CURSOR reservation_check(org_id NUMBER, sub_inv_code VARCHAR2,item_id NUMBER)
4456: IS
4457: SELECT (REQUIRED_QUANTITY-ORDERED_QUANTITY)
4458: FROM CSP_REQUIREMENT_LINES
4459: WHERE REQUIREMENT_HEADER_ID = (SELECT REQUIREMENT_HEADER_ID
4460: FROM CSP_REQUIREMENT_HEADERS
4461: WHERE OPEN_REQUIREMENT = 'Yes'
4462: AND DESTINATION_ORGANIZATION_ID = org_id)

Line 5510: ,csp_requirement_lines crl

5506:
5507: CURSOR get_reservations is
5508: select crld.source_id , crld.req_line_detail_id
5509: from csp_req_line_details crld
5510: ,csp_requirement_lines crl
5511: ,csp_requirement_headers crh
5512: where crh.task_id = l_task_id
5513: and crl.requirement_header_id = crh.requirement_header_id
5514: and crld.requirement_line_id = crl.requirement_line_id

Line 5520: ,csp_requirement_lines crl

5516:
5517: CURSOR get_orders is
5518: select oeh.header_id, crld.req_line_detail_id
5519: from csp_req_line_details crld
5520: ,csp_requirement_lines crl
5521: ,csp_requirement_headers crh
5522: ,oe_order_lines_all oel
5523: ,oe_order_headers_all oeh
5524: where crh.task_id = l_task_id

Line 5609: csp_requirement_lines crl,

5605: rcl.quantity_received quantity_received,crld.req_line_detail_id req_line_detail_id
5606: from mtl_material_transactions mmt,RCV_SHIPMENT_headers rsh,
5607: rcv_shipment_lines rcl,
5608: oe_order_lines_all oola,csp_req_line_details crld,
5609: csp_requirement_lines crl,
5610: csp_requirement_headers crh
5611: where mmt.transaction_id = p_transaction_id
5612: and mmt.shipment_number = rsh.shipment_num
5613: and rsh.shipment_header_id = rcl.shipment_header_id

Line 5629: csp_requirement_lines crl,csp_requirement_headers crh

5625: crld.requirement_line_id requirement_line_id, mmt.transaction_quantity quantity_shipped,
5626: mmt.transaction_quantity quantity_received,crld.req_line_detail_id req_line_detail_id
5627: from mtl_material_transactions mmt,
5628: oe_order_lines_all oola,csp_req_line_details crld,
5629: csp_requirement_lines crl,csp_requirement_headers crh
5630: where mmt.transaction_id = p_transaction_id
5631: and oola.source_document_id = mmt.transaction_source_id
5632: and crld.source_id = oola.line_id
5633: and (mmt.source_code = 'ORDER ENTRY')