DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on OE_ORDER_LINES_ALL

Line 2818: oe_order_lines_all oel

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
2822: and line.requirement_line_id = dtl.requirement_line_id

Line 2850: oe_order_lines_all oel

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
2854: AND ch.requirement_header_id = cl.requirement_header_id

Line 3007: from oe_order_lines_all

3003:
3004:
3005: select nvl(cancelled_flag, 'N')
3006: into l_is_cancelled
3007: from oe_order_lines_all
3008: where line_id = l_source_id;
3009:
3010: if l_is_cancelled = 'N' then -- entered status
3011: -- check ship to type

Line 3059: FROM oe_order_lines_all

3055: SET destination_subinventory = l_subinventory_code,
3056: destination_organization_id = l_organization_id
3057: WHERE requisition_line_id =
3058: (SELECT source_document_line_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);

Line 3216: oe_order_lines_all oola

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
3220: AND l.requirement_line_id = d.requirement_line_id

Line 3250: oe_order_lines_all oola,

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
3254: AND h.address_type IN ('R', 'S')

Line 3277: oe_order_lines_all oola,

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
3281: AND h.address_type IN ('R', 'S')

Line 3307: oe_order_lines_all oola,

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
3311: AND h.address_type IN ('T', 'C', 'P')

Line 3339: oe_order_lines_all oola,

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
3343: AND h.address_type IN ('T', 'C', 'P')

Line 3393: oe_order_lines_all oola,

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
3397: AND h.address_type IN ('T', 'C', 'P')

Line 3446: oe_order_lines_all oola,

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
3450: AND h.address_type IN ('T', 'C', 'P')

Line 3509: oe_order_lines_all oola

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
3513: AND l.requirement_line_id = d.requirement_line_id

Line 3543: oe_order_lines_all oola,

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
3547: AND h.requirement_header_id = l.requirement_header_id

Line 3572: oe_order_lines_all oola

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
3576: AND l.requirement_line_id = d.requirement_line_id

Line 3617: oe_order_lines_all oola

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
3621: AND l.requirement_line_id = d.requirement_line_id

Line 3661: oe_order_lines_all oola

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
3665: AND l.requirement_line_id = d.requirement_line_id