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_HEADERS

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 348: FROM CSP_REQUIREMENT_HEADERS crh

344: ,x_msg_count OUT NOCOPY NUMBER) IS
345:
346: CURSOR C2 IS
347: SELECT crh.REQUIREMENT_HEADER_ID,crh.address_type
348: FROM CSP_REQUIREMENT_HEADERS crh
349: WHERE crh.TASK_ID = p_task_id;
350:
351:
352: CURSOR csp_resource_org(c_resource_id number, c_resource_type varchar2) IS

Line 383: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_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;
386: l_revision varchar2(3);
387: l_ship_set varchar2(3);

Line 724: CSP_Requirement_Headers_PVT.Update_requirement_headers(

720: l_requirement_header.address_type := 'R';
721: l_requirement_header.ship_to_location_id := l_ship_to_location_id;
722: END IF;
723: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
724: CSP_Requirement_Headers_PVT.Update_requirement_headers(
725: P_Api_Version_Number => 1.0,
726: P_Init_Msg_List => FND_API.G_FALSE,
727: P_Commit => FND_API.G_FALSE,
728: 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 932: ,csp_requirement_headers crh

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
936: and crld.source_type = 'RES' ;

Line 942: ,csp_requirement_headers crh

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
946: and crl.requirement_header_id = crh.requirement_header_id

Line 967: from csp_requirement_headers

963: and oel.header_id = c_order_header_id;
964:
965: cursor get_requirement_header_id is
966: select requirement_header_id,address_type
967: from csp_requirement_headers
968: where task_assignment_id = p_task_assignment_id;
969:
970: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
971: l_requirement_header_id NUMBER;

Line 970: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;

966: select requirement_header_id,address_type
967: from csp_requirement_headers
968: where task_assignment_id = p_task_assignment_id;
969:
970: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
971: l_requirement_header_id NUMBER;
972: l_address_type varchar2(3);
973: BEGIN
974:

Line 1033: CSP_Requirement_Headers_PVT.Update_requirement_headers(

1029: l_requirement_header.resource_type := null;
1030: l_requirement_header.resource_id := null;
1031: l_requirement_header.destination_organization_id := null;
1032: l_requirement_header.destination_subinventory := null;
1033: CSP_Requirement_Headers_PVT.Update_requirement_headers(
1034: P_Api_Version_Number => 1.0,
1035: P_Init_Msg_List => FND_API.G_FALSE,
1036: P_Commit => FND_API.G_FALSE,
1037: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1130: ,csp_requirement_headers crh

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
1134: and crl.requirement_header_id = crh.requirement_header_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 1216: from CSP_REQUIREMENT_HEADERS

1212:
1213: */
1214: /*CURSOR C1(c_task_assignment number) is
1215: select REQUIREMENT_HEADER_ID
1216: from CSP_REQUIREMENT_HEADERS
1217: where TASK_ASSIGNMENT_ID = c_task_assignment;
1218: CURSOR C2(c_header_id number) is
1219: SELECT INVENTORY_ITEM_ID, UOM_CODE,REVISION
1220: ,SHIP_COMPLETE_FLAG,SOURCE_ORGANIZATION_ID

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 1564: FROM CSP_REQUIREMENT_HEADERS

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)
1567: AND SOURCE_SUBINVENTORY = sub_inv_code
1568: AND INVENTORY_ITEM_ID = item_id

Line 4460: FROM CSP_REQUIREMENT_HEADERS

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)
4463: AND SOURCE_SUBINVENTORY = sub_inv_code
4464: AND INVENTORY_ITEM_ID = item_id

Line 5511: ,csp_requirement_headers crh

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
5515: and crld.source_type = 'RES' ;

Line 5521: ,csp_requirement_headers crh

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
5525: and crl.requirement_header_id = crh.requirement_header_id

Line 5610: csp_requirement_headers crh

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
5614: and oola.source_document_line_id = rcl.requisition_line_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')