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_PARTS_REQUIREMENT dependencies on CSP_REQ_LINE_DETAILS

Line 678: SELECT csp_req_line_Details_s1.nextval

674: END IF;
675: END IF;
676: FOR I IN 1..x_rqmt_line_tbl.count LOOP
677: IF x_rqmt_line_tbl(I).order_line_id IS NOT NULL THEN
678: SELECT csp_req_line_Details_s1.nextval
679: INTO l_req_line_Dtl_id
680: FROM dual;
681:
682: csp_req_line_Details_pkg.Insert_Row(

Line 682: csp_req_line_Details_pkg.Insert_Row(

678: SELECT csp_req_line_Details_s1.nextval
679: INTO l_req_line_Dtl_id
680: FROM dual;
681:
682: csp_req_line_Details_pkg.Insert_Row(
683: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
684: p_REQUIREMENT_LINE_ID => x_rqmt_line_tbl(I).requirement_line_id,
685: p_CREATED_BY => nvl(l_user_id, 1),
686: p_CREATION_DATE => sysdate,

Line 1201: SELECT csp_req_line_Details_s1.nextval

1197: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1198: RAISE FND_API.G_EXC_ERROR;
1199: ELSE
1200: -- code for inserting into req line dtls
1201: SELECT csp_req_line_Details_s1.nextval
1202: INTO l_req_line_Dtl_id
1203: FROM dual;
1204:
1205: csp_req_line_Details_pkg.Insert_Row(

Line 1205: csp_req_line_Details_pkg.Insert_Row(

1201: SELECT csp_req_line_Details_s1.nextval
1202: INTO l_req_line_Dtl_id
1203: FROM dual;
1204:
1205: csp_req_line_Details_pkg.Insert_Row(
1206: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1207: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1208: p_CREATED_BY => nvl(l_user_id, 1),
1209: p_CREATION_DATE => sysdate,

Line 1243: -- insert record in csp_req_line_details table with order information

1239:
1240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1241: RAISE FND_API.G_EXC_ERROR;
1242: ELSE
1243: -- insert record in csp_req_line_details table with order information
1244: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
1245: l_line_rec := l_oe_line_tbl(I);
1246:
1247: SELECT csp_req_line_Details_s1.nextval

Line 1247: SELECT csp_req_line_Details_s1.nextval

1243: -- insert record in csp_req_line_details table with order information
1244: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
1245: l_line_rec := l_oe_line_tbl(I);
1246:
1247: SELECT csp_req_line_Details_s1.nextval
1248: INTO l_req_line_Dtl_id
1249: FROM dual;
1250:
1251: csp_req_line_Details_pkg.Insert_Row(

Line 1251: csp_req_line_Details_pkg.Insert_Row(

1247: SELECT csp_req_line_Details_s1.nextval
1248: INTO l_req_line_Dtl_id
1249: FROM dual;
1250:
1251: csp_req_line_Details_pkg.Insert_Row(
1252: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1253: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1254: p_CREATED_BY => nvl(l_user_id, 1),
1255: p_CREATION_DATE => sysdate,

Line 1281: -- insert into csp_req_line_Details table with purchase req information

1277:
1278: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1279: RAISE FND_API.G_EXC_ERROR;
1280: ELSE
1281: -- insert into csp_req_line_Details table with purchase req information
1282: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1283: l_line_rec := l_po_line_tbl(I);
1284:
1285: SELECT csp_req_line_Details_s1.nextval

Line 1285: SELECT csp_req_line_Details_s1.nextval

1281: -- insert into csp_req_line_Details table with purchase req information
1282: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1283: l_line_rec := l_po_line_tbl(I);
1284:
1285: SELECT csp_req_line_Details_s1.nextval
1286: INTO l_req_line_Dtl_id
1287: FROM dual;
1288:
1289: csp_req_line_Details_pkg.Insert_Row(

Line 1289: csp_req_line_Details_pkg.Insert_Row(

1285: SELECT csp_req_line_Details_s1.nextval
1286: INTO l_req_line_Dtl_id
1287: FROM dual;
1288:
1289: csp_req_line_Details_pkg.Insert_Row(
1290: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1291: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1292: p_CREATED_BY => nvl(l_user_id, 1),
1293: p_CREATION_DATE => sysdate,

Line 1369: FROM csp_requirement_lines crl, csp_req_line_Details crld

1365:
1366: IF (p_header_id IS NOT NULL) THEN
1367: SELECT count(*)
1368: INTO l_count
1369: FROM csp_requirement_lines crl, csp_req_line_Details crld
1370: WHERE crl.requirement_header_id = p_header_id
1371: AND crl.requirement_line_id = crld.requirement_line_id;
1372:
1373: IF l_count > 0 THEN

Line 1481: csp_req_line_details crld

1477: crl.revision,
1478: crl.required_quantity,
1479: crl.uom_code
1480: from csp_requirement_lines crl,
1481: csp_req_line_details crld
1482: where crld.requirement_line_id(+) = crl.requirement_line_id
1483: and crl.requirement_header_id = p_rqmt_header_id
1484: and crld.source_id is null;
1485:

Line 2028: csp_req_line_details crld

2024: crl.inventory_item_id,
2025: crl.uom_code,
2026: crl.required_quantity
2027: from csp_requirement_lines crl,
2028: csp_req_line_details crld
2029: where crld.requirement_line_id(+) = crl.requirement_line_id
2030: and crl.requirement_header_id = p_header_id
2031: and crld.source_id is null;
2032:

Line 2057: csp_req_line_details crld

2053: IF (p_header_id IS NOT NULL) THEN
2054: select count(*)
2055: into l_count
2056: from csp_requirement_lines crl,
2057: csp_req_line_details crld
2058: where crld.requirement_line_id(+) = crl.requirement_line_id
2059: and crl.requirement_header_id = p_header_id
2060: and crld.source_id is null;
2061:

Line 2291: AND not exists (select 1 from csp_req_line_Details d where d.requirement_line_id = c.requirement_line_id)

2287: c.shipping_method_code,
2288: c.arrival_date
2289: FROM csp_requirement_lines c
2290: WHERE c.requirement_header_id = p_header_id
2291: AND not exists (select 1 from csp_req_line_Details d where d.requirement_line_id = c.requirement_line_id)
2292: FOR UPDATE of c.order_line_id NOWAIT;
2293:
2294: BEGIN
2295:

Line 2337: csp_req_line_details crld

2333: IF (p_header_id IS NOT NULL) THEN
2334: select count(*)
2335: into l_count
2336: from csp_requirement_lines crl,
2337: csp_req_line_details crld
2338: where crld.requirement_line_id(+) = crl.requirement_line_id
2339: and crl.requirement_header_id = p_header_id
2340: and crld.source_id is null;
2341:

Line 2507: SELECT csp_req_line_Details_s1.nextval

2503: -- update csp_requirement_line table with order information
2504: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
2505: l_line_rec := l_oe_line_tbl(I);
2506:
2507: SELECT csp_req_line_Details_s1.nextval
2508: INTO l_req_line_Dtl_id
2509: FROM dual;
2510:
2511: csp_req_line_Details_pkg.Insert_Row(

Line 2511: csp_req_line_Details_pkg.Insert_Row(

2507: SELECT csp_req_line_Details_s1.nextval
2508: INTO l_req_line_Dtl_id
2509: FROM dual;
2510:
2511: csp_req_line_Details_pkg.Insert_Row(
2512: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2513: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
2514: p_CREATED_BY => nvl(l_user_id, 1),
2515: p_CREATION_DATE => sysdate,

Line 2555: -- insert into csp_req_line_Details table with purchase req information

2551: x_order_tbl(2).source_type := 'POREQ';
2552: x_order_tbl(2).order_number := l_header_rec.requisition_number;
2553: -- x_order_tbl(2).line_tbl := l_po_line_tbl;
2554:
2555: -- insert into csp_req_line_Details table with purchase req information
2556: FOR I IN 1..l_po_line_tbl.COUNT LOOP
2557: l_line_rec := l_po_line_tbl(I);
2558:
2559: SELECT csp_req_line_Details_s1.nextval

Line 2559: SELECT csp_req_line_Details_s1.nextval

2555: -- insert into csp_req_line_Details table with purchase req information
2556: FOR I IN 1..l_po_line_tbl.COUNT LOOP
2557: l_line_rec := l_po_line_tbl(I);
2558:
2559: SELECT csp_req_line_Details_s1.nextval
2560: INTO l_req_line_Dtl_id
2561: FROM dual;
2562:
2563: csp_req_line_Details_pkg.Insert_Row(

Line 2563: csp_req_line_Details_pkg.Insert_Row(

2559: SELECT csp_req_line_Details_s1.nextval
2560: INTO l_req_line_Dtl_id
2561: FROM dual;
2562:
2563: csp_req_line_Details_pkg.Insert_Row(
2564: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2565: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
2566: p_CREATED_BY => nvl(l_user_id, 1),
2567: p_CREATION_DATE => sysdate,