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 693: SELECT csp_req_line_Details_s1.nextval

689: END IF;
690: END IF;
691: FOR I IN 1..x_rqmt_line_tbl.count LOOP
692: IF x_rqmt_line_tbl(I).order_line_id IS NOT NULL THEN
693: SELECT csp_req_line_Details_s1.nextval
694: INTO l_req_line_Dtl_id
695: FROM dual;
696:
697: csp_req_line_Details_pkg.Insert_Row(

Line 697: csp_req_line_Details_pkg.Insert_Row(

693: SELECT csp_req_line_Details_s1.nextval
694: INTO l_req_line_Dtl_id
695: FROM dual;
696:
697: csp_req_line_Details_pkg.Insert_Row(
698: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
699: p_REQUIREMENT_LINE_ID => x_rqmt_line_tbl(I).requirement_line_id,
700: p_CREATED_BY => nvl(l_user_id, 1),
701: p_CREATION_DATE => sysdate,

Line 1310: SELECT csp_req_line_Details_s1.nextval

1306: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSE
1309: -- code for inserting into req line dtls
1310: SELECT csp_req_line_Details_s1.nextval
1311: INTO l_req_line_Dtl_id
1312: FROM dual;
1313:
1314: csp_req_line_Details_pkg.Insert_Row(

Line 1314: csp_req_line_Details_pkg.Insert_Row(

1310: SELECT csp_req_line_Details_s1.nextval
1311: INTO l_req_line_Dtl_id
1312: FROM dual;
1313:
1314: csp_req_line_Details_pkg.Insert_Row(
1315: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1316: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1317: p_CREATED_BY => nvl(l_user_id, 1),
1318: p_CREATION_DATE => sysdate,

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

1348:
1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: RAISE FND_API.G_EXC_ERROR;
1351: ELSE
1352: -- insert record in csp_req_line_details table with order information
1353: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
1354: l_line_rec := l_oe_line_tbl(I);
1355:
1356: SELECT csp_req_line_Details_s1.nextval

Line 1356: SELECT csp_req_line_Details_s1.nextval

1352: -- insert record in csp_req_line_details table with order information
1353: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
1354: l_line_rec := l_oe_line_tbl(I);
1355:
1356: SELECT csp_req_line_Details_s1.nextval
1357: INTO l_req_line_Dtl_id
1358: FROM dual;
1359:
1360: csp_req_line_Details_pkg.Insert_Row(

Line 1360: csp_req_line_Details_pkg.Insert_Row(

1356: SELECT csp_req_line_Details_s1.nextval
1357: INTO l_req_line_Dtl_id
1358: FROM dual;
1359:
1360: csp_req_line_Details_pkg.Insert_Row(
1361: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1362: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1363: p_CREATED_BY => nvl(l_user_id, 1),
1364: p_CREATION_DATE => sysdate,

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

1386:
1387: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: ELSE
1390: -- insert into csp_req_line_Details table with purchase req information
1391: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1392: l_line_rec := l_po_line_tbl(I);
1393:
1394: SELECT csp_req_line_Details_s1.nextval

Line 1394: SELECT csp_req_line_Details_s1.nextval

1390: -- insert into csp_req_line_Details table with purchase req information
1391: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1392: l_line_rec := l_po_line_tbl(I);
1393:
1394: SELECT csp_req_line_Details_s1.nextval
1395: INTO l_req_line_Dtl_id
1396: FROM dual;
1397:
1398: csp_req_line_Details_pkg.Insert_Row(

Line 1398: csp_req_line_Details_pkg.Insert_Row(

1394: SELECT csp_req_line_Details_s1.nextval
1395: INTO l_req_line_Dtl_id
1396: FROM dual;
1397:
1398: csp_req_line_Details_pkg.Insert_Row(
1399: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1400: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1401: p_CREATED_BY => nvl(l_user_id, 1),
1402: p_CREATION_DATE => sysdate,

Line 1482: FROM csp_requirement_lines crl, csp_req_line_Details crld

1478:
1479: IF (p_header_id IS NOT NULL) THEN
1480: SELECT count(*)
1481: INTO l_count
1482: FROM csp_requirement_lines crl, csp_req_line_Details crld
1483: WHERE crl.requirement_header_id = p_header_id
1484: AND crl.requirement_line_id = crld.requirement_line_id;
1485:
1486: IF l_count > 0 THEN

Line 1595: csp_req_line_details crld

1591: crl.revision,
1592: crl.required_quantity,
1593: crl.uom_code
1594: from csp_requirement_lines crl,
1595: csp_req_line_details crld
1596: where crld.requirement_line_id(+) = crl.requirement_line_id
1597: and crl.requirement_header_id = p_rqmt_header_id
1598: and crld.source_id is null;
1599:

Line 2144: csp_req_line_details crld

2140: crl.inventory_item_id,
2141: crl.uom_code,
2142: crl.required_quantity
2143: from csp_requirement_lines crl,
2144: csp_req_line_details crld
2145: where crld.requirement_line_id(+) = crl.requirement_line_id
2146: and crl.requirement_header_id = p_header_id
2147: and crld.source_id is null;
2148:

Line 2173: csp_req_line_details crld

2169: IF (p_header_id IS NOT NULL) THEN
2170: select count(*)
2171: into l_count
2172: from csp_requirement_lines crl,
2173: csp_req_line_details crld
2174: where crld.requirement_line_id(+) = crl.requirement_line_id
2175: and crl.requirement_header_id = p_header_id
2176: and crld.source_id is null;
2177:

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

2407: c.shipping_method_code,
2408: c.arrival_date
2409: FROM csp_requirement_lines c
2410: WHERE c.requirement_header_id = p_header_id
2411: AND not exists (select 1 from csp_req_line_Details d where d.requirement_line_id = c.requirement_line_id)
2412: FOR UPDATE of c.order_line_id NOWAIT;
2413:
2414: BEGIN
2415:

Line 2457: csp_req_line_details crld

2453: IF (p_header_id IS NOT NULL) THEN
2454: select count(*)
2455: into l_count
2456: from csp_requirement_lines crl,
2457: csp_req_line_details crld
2458: where crld.requirement_line_id(+) = crl.requirement_line_id
2459: and crl.requirement_header_id = p_header_id
2460: and crld.source_id is null;
2461:

Line 2627: SELECT csp_req_line_Details_s1.nextval

2623: -- update csp_requirement_line table with order information
2624: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
2625: l_line_rec := l_oe_line_tbl(I);
2626:
2627: SELECT csp_req_line_Details_s1.nextval
2628: INTO l_req_line_Dtl_id
2629: FROM dual;
2630:
2631: csp_req_line_Details_pkg.Insert_Row(

Line 2631: csp_req_line_Details_pkg.Insert_Row(

2627: SELECT csp_req_line_Details_s1.nextval
2628: INTO l_req_line_Dtl_id
2629: FROM dual;
2630:
2631: csp_req_line_Details_pkg.Insert_Row(
2632: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2633: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
2634: p_CREATED_BY => nvl(l_user_id, 1),
2635: p_CREATION_DATE => sysdate,

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

2671: x_order_tbl(2).source_type := 'POREQ';
2672: x_order_tbl(2).order_number := l_header_rec.requisition_number;
2673: -- x_order_tbl(2).line_tbl := l_po_line_tbl;
2674:
2675: -- insert into csp_req_line_Details table with purchase req information
2676: FOR I IN 1..l_po_line_tbl.COUNT LOOP
2677: l_line_rec := l_po_line_tbl(I);
2678:
2679: SELECT csp_req_line_Details_s1.nextval

Line 2679: SELECT csp_req_line_Details_s1.nextval

2675: -- insert into csp_req_line_Details table with purchase req information
2676: FOR I IN 1..l_po_line_tbl.COUNT LOOP
2677: l_line_rec := l_po_line_tbl(I);
2678:
2679: SELECT csp_req_line_Details_s1.nextval
2680: INTO l_req_line_Dtl_id
2681: FROM dual;
2682:
2683: csp_req_line_Details_pkg.Insert_Row(

Line 2683: csp_req_line_Details_pkg.Insert_Row(

2679: SELECT csp_req_line_Details_s1.nextval
2680: INTO l_req_line_Dtl_id
2681: FROM dual;
2682:
2683: csp_req_line_Details_pkg.Insert_Row(
2684: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2685: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
2686: p_CREATED_BY => nvl(l_user_id, 1),
2687: p_CREATION_DATE => sysdate,

Line 2817: csp_req_line_details dtl,

2813: select head.requirement_header_id, count(dtl.source_type)
2814: from
2815: csp_requirement_headers head,
2816: csp_requirement_lines line,
2817: csp_req_line_details dtl,
2818: oe_order_lines_all oel
2819: where
2820: head.task_assignment_id = l_Task_Assignment_id
2821: and head.requirement_header_id = line.requirement_header_id

Line 2833: csp_req_line_details dtl

2829: select dtl.req_line_detail_id, dtl.source_id, dtl.source_type
2830: from
2831: csp_requirement_headers head,
2832: csp_requirement_lines line,
2833: csp_req_line_details dtl
2834: where
2835: head.requirement_header_id = v_req_header_id
2836: and head.requirement_header_id = line.requirement_header_id
2837: and line.requirement_line_id = dtl.requirement_line_id;

Line 2849: csp_req_line_details cld,

2845: SELECT oel.header_id
2846: FROM jtf_task_assignments jta,
2847: csp_requirement_headers ch,
2848: csp_requirement_lines cl,
2849: csp_req_line_details cld,
2850: oe_order_lines_all oel
2851: WHERE jta.task_assignment_id = l_task_assignment_id
2852: AND ch.task_assignment_id = jta.task_assignment_id
2853: AND ch.task_id = jta.task_id

Line 2902: FROM csp_req_line_details d

2898: WHERE h.task_id = l_task_id
2899: AND h.task_assignment_id = l_task_assignment_id
2900: AND l.requirement_header_id = h.requirement_header_id
2901: AND (SELECT COUNT(d.source_id)
2902: FROM csp_req_line_details d
2903: WHERE d.requirement_line_id = l.requirement_line_id) = 0;
2904:
2905: BEGIN
2906:

Line 3063: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);

3059: FROM oe_order_lines_all
3060: WHERE line_id = l_source_id);
3061:
3062: else
3063: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);
3064: end if; -- if l_is_cancelled = 'N' then -- entered status
3065:
3066:
3067: elsif l_source_type = 'RES' then

Line 3088: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);

3084: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3085: FND_MSG_PUB.ADD;
3086: raise EXCP_USER_DEFINED;
3087: else
3088: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);
3089: end if;
3090:
3091: -- we need to source the part for the new tech
3092: l_sch_option.resource_id := l_resource_id;

Line 3215: csp_req_line_details d,

3211: SELECT count(l.requirement_line_id)
3212: into l_partial_line
3213: FROM csp_requirement_headers h,
3214: csp_requirement_lines l,
3215: csp_req_line_details d,
3216: oe_order_lines_all oola
3217: WHERE h.task_id = l_task_id
3218: AND h.task_assignment_id = l_Task_Assignment_id
3219: AND h.requirement_header_id = l.requirement_header_id

Line 3248: csp_req_line_details dio,

3244: SELECT COUNT(l.requirement_line_id)
3245: into l_fl_rcvd_lines
3246: FROM csp_requirement_headers h,
3247: csp_requirement_lines l,
3248: csp_req_line_details dio,
3249: csp_req_line_details dres,
3250: oe_order_lines_all oola,
3251: mtl_reservations mr
3252: WHERE h.task_id = l_task_id

Line 3249: csp_req_line_details dres,

3245: into l_fl_rcvd_lines
3246: FROM csp_requirement_headers h,
3247: csp_requirement_lines l,
3248: csp_req_line_details dio,
3249: csp_req_line_details dres,
3250: oe_order_lines_all oola,
3251: mtl_reservations mr
3252: WHERE h.task_id = l_task_id
3253: AND h.task_assignment_id = l_Task_Assignment_id

Line 3276: csp_req_line_details dio,

3272: SELECT ooha.order_number
3273: into l_order_number
3274: FROM csp_requirement_headers h,
3275: csp_requirement_lines l,
3276: csp_req_line_details dio,
3277: oe_order_lines_all oola,
3278: oe_order_headers_all ooha
3279: WHERE h.task_id = l_task_id
3280: AND h.task_assignment_id = l_Task_Assignment_id

Line 3305: csp_req_line_details dio,

3301: SELECT COUNT(l.requirement_line_id)
3302: into l_fl_rcvd_lines
3303: FROM csp_requirement_headers h,
3304: csp_requirement_lines l,
3305: csp_req_line_details dio,
3306: csp_req_line_details dres,
3307: oe_order_lines_all oola,
3308: mtl_reservations mr
3309: WHERE h.task_id = l_task_id

Line 3306: csp_req_line_details dres,

3302: into l_fl_rcvd_lines
3303: FROM csp_requirement_headers h,
3304: csp_requirement_lines l,
3305: csp_req_line_details dio,
3306: csp_req_line_details dres,
3307: oe_order_lines_all oola,
3308: mtl_reservations mr
3309: WHERE h.task_id = l_task_id
3310: AND h.task_assignment_id = l_Task_Assignment_id

Line 3336: csp_req_line_details dio,

3332: SELECT COUNT(l.requirement_line_id)
3333: into l_fl_rcvd_multi_source
3334: FROM csp_requirement_headers h,
3335: csp_requirement_lines l,
3336: csp_req_line_details dio,
3337: csp_req_line_details dres,
3338: csp_req_line_details dother,
3339: oe_order_lines_all oola,
3340: mtl_reservations mr

Line 3337: csp_req_line_details dres,

3333: into l_fl_rcvd_multi_source
3334: FROM csp_requirement_headers h,
3335: csp_requirement_lines l,
3336: csp_req_line_details dio,
3337: csp_req_line_details dres,
3338: csp_req_line_details dother,
3339: oe_order_lines_all oola,
3340: mtl_reservations mr
3341: WHERE h.task_id = l_task_id

Line 3338: csp_req_line_details dother,

3334: FROM csp_requirement_headers h,
3335: csp_requirement_lines l,
3336: csp_req_line_details dio,
3337: csp_req_line_details dres,
3338: csp_req_line_details dother,
3339: oe_order_lines_all oola,
3340: mtl_reservations mr
3341: WHERE h.task_id = l_task_id
3342: AND h.task_assignment_id = l_Task_Assignment_id

Line 3381: csp_req_line_details d

3377: FROM
3378: (SELECT l.requirement_line_id
3379: FROM csp_requirement_headers h,
3380: csp_requirement_lines l,
3381: csp_req_line_details d
3382: WHERE h.task_id = l_task_id
3383: AND h.task_assignment_id = l_Task_Assignment_id
3384: AND h.requirement_header_id = l.requirement_header_id
3385: AND h.address_type IN ('T', 'C', 'P')

Line 3391: csp_req_line_details dio,

3387: MINUS
3388: SELECT l.requirement_line_id
3389: FROM csp_requirement_headers h,
3390: csp_requirement_lines l,
3391: csp_req_line_details dio,
3392: csp_req_line_details dres,
3393: oe_order_lines_all oola,
3394: mtl_reservations mr
3395: WHERE h.task_id = l_task_id

Line 3392: csp_req_line_details dres,

3388: SELECT l.requirement_line_id
3389: FROM csp_requirement_headers h,
3390: csp_requirement_lines l,
3391: csp_req_line_details dio,
3392: csp_req_line_details dres,
3393: oe_order_lines_all oola,
3394: mtl_reservations mr
3395: WHERE h.task_id = l_task_id
3396: AND h.task_assignment_id = l_Task_Assignment_id

Line 3438: FROM csp_req_line_details d

3434: AND h.task_assignment_id = l_Task_Assignment_id
3435: AND h.requirement_header_id = l.requirement_header_id
3436: AND h.address_type IN ('T', 'C', 'P')
3437: AND (SELECT COUNT (d.requirement_line_id)
3438: FROM csp_req_line_details d
3439: WHERE d.requirement_line_id = l.requirement_line_id) = 0
3440: MINUS
3441: SELECT l.requirement_line_id
3442: FROM csp_requirement_headers h,

Line 3444: csp_req_line_details dio,

3440: MINUS
3441: SELECT l.requirement_line_id
3442: FROM csp_requirement_headers h,
3443: csp_requirement_lines l,
3444: csp_req_line_details dio,
3445: csp_req_line_details dres,
3446: oe_order_lines_all oola,
3447: mtl_reservations mr
3448: WHERE h.task_id = l_task_id

Line 3445: csp_req_line_details dres,

3441: SELECT l.requirement_line_id
3442: FROM csp_requirement_headers h,
3443: csp_requirement_lines l,
3444: csp_req_line_details dio,
3445: csp_req_line_details dres,
3446: oe_order_lines_all oola,
3447: mtl_reservations mr
3448: WHERE h.task_id = l_task_id
3449: AND h.task_assignment_id = l_Task_Assignment_id

Line 3508: csp_req_line_details d,

3504: SELECT COUNT(l.requirement_line_id)
3505: into l_shpd_lines
3506: FROM csp_requirement_headers h,
3507: csp_requirement_lines l,
3508: csp_req_line_details d,
3509: oe_order_lines_all oola
3510: WHERE h.task_id = l_task_id
3511: AND h.task_assignment_id = l_Task_Assignment_id
3512: AND h.requirement_header_id = l.requirement_header_id

Line 3542: csp_req_line_details d,

3538: SELECT ooha.order_number
3539: INTO l_order_number
3540: FROM csp_requirement_headers h,
3541: csp_requirement_lines l,
3542: csp_req_line_details d,
3543: oe_order_lines_all oola,
3544: oe_order_headers_all ooha
3545: WHERE h.task_assignment_id = l_Task_Assignment_id
3546: AND h.task_id = l_task_id

Line 3570: csp_req_line_details d,

3566: SELECT COUNT(l.requirement_line_id)
3567: into l_ship_multi_src
3568: FROM csp_requirement_headers h,
3569: csp_requirement_lines l,
3570: csp_req_line_details d,
3571: csp_req_line_details dother,
3572: oe_order_lines_all oola
3573: WHERE h.task_id = l_task_id
3574: AND h.task_assignment_id = l_Task_Assignment_id

Line 3571: csp_req_line_details dother,

3567: into l_ship_multi_src
3568: FROM csp_requirement_headers h,
3569: csp_requirement_lines l,
3570: csp_req_line_details d,
3571: csp_req_line_details dother,
3572: oe_order_lines_all oola
3573: WHERE h.task_id = l_task_id
3574: AND h.task_assignment_id = l_Task_Assignment_id
3575: AND h.requirement_header_id = l.requirement_header_id

Line 3607: csp_req_line_details d

3603: FROM
3604: (SELECT l.requirement_line_id
3605: FROM csp_requirement_headers h,
3606: csp_requirement_lines l,
3607: csp_req_line_details d
3608: WHERE h.task_id = l_task_id
3609: AND h.task_assignment_id = l_Task_Assignment_id
3610: AND h.requirement_header_id = l.requirement_header_id
3611: AND l.requirement_line_id = d.requirement_line_id

Line 3616: csp_req_line_details d,

3612: MINUS
3613: SELECT l.requirement_line_id
3614: FROM csp_requirement_headers h,
3615: csp_requirement_lines l,
3616: csp_req_line_details d,
3617: oe_order_lines_all oola
3618: WHERE h.task_id = l_task_id
3619: AND h.task_assignment_id = l_Task_Assignment_id
3620: AND h.requirement_header_id = l.requirement_header_id

Line 3654: FROM csp_req_line_details d

3650: WHERE h.task_id = l_task_id
3651: AND h.task_assignment_id = l_Task_Assignment_id
3652: AND h.requirement_header_id = l.requirement_header_id
3653: AND (SELECT COUNT (d.requirement_line_id)
3654: FROM csp_req_line_details d
3655: WHERE d.requirement_line_id = l.requirement_line_id) = 0
3656: MINUS
3657: SELECT l.requirement_line_id
3658: FROM csp_requirement_headers h,

Line 3660: csp_req_line_details d,

3656: MINUS
3657: SELECT l.requirement_line_id
3658: FROM csp_requirement_headers h,
3659: csp_requirement_lines l,
3660: csp_req_line_details d,
3661: oe_order_lines_all oola
3662: WHERE h.task_id = l_task_id
3663: AND h.task_assignment_id = l_Task_Assignment_id
3664: AND h.requirement_header_id = l.requirement_header_id

Line 4161: FROM csp_req_line_details rld,

4157: AND rh.task_id = jta.task_id
4158: AND rh.task_assignment_id IS NULL
4159: AND NOT EXISTS
4160: (SELECT 1
4161: FROM csp_req_line_details rld,
4162: csp_requirement_lines rl
4163: WHERE rl.requirement_line_id = rld.requirement_line_id
4164: AND rl.requirement_header_id = rh.requirement_header_id);
4165:

Line 4553: csp_req_line_details d

4549: SELECT COUNT(*)
4550: INTO l_dtl_count
4551: FROM csp_requirement_headers h,
4552: csp_requirement_lines l,
4553: csp_req_line_details d
4554: WHERE h.task_assignment_id = l_task_assignment_id
4555: AND h.task_id = l_task_id
4556: AND h.requirement_header_id = l.requirement_header_id
4557: AND l.requirement_line_id = d.requirement_line_id;