APPS.WIP_OSP dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 507: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL

503: /* Create the requisition */
504: IF Additional_Quantity > 0 THEN
505: /* This additional_quantity is set to the increased quantity
506: of the job that is modified by the user. */
507: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
508: ( last_update_date, last_updated_by, creation_date,
509: created_by, last_update_login, request_id,
510: program_application_id, program_id, program_update_date,
511: org_id, /* Operating unit org */ preparer_id,

Line 702: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL

698: AND bcd3.seq_num = (bcd4.next_seq_num -
699: CEIL(NVL(msi.postprocessing_lead_time,0)));
700:
701: ELSE
702: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
703: ( last_update_date, last_updated_by, creation_date,
704: created_by, last_update_login, request_id,
705: program_application_id, program_id, program_update_date,
706: org_id, /* Operating unit org */ preparer_id,

Line 1016: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

1012: AND PRL.LINE_LOCATION_ID is NULL /* added as part of 2740352 */
1013: AND NVL(PRL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED' /* BUG:13019044 Added condition of Finally Closed requisition lines */
1014: UNION ALL
1015: SELECT 'PO/REQ Linked'
1016: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
1017: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
1018: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
1019: AND (p_op_seq_num is NULL OR PRI.WIP_OPERATION_SEQ_NUM = p_op_seq_num);
1020:

Line 1060: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

1056: AND nvl(PRL.cancel_flag, 'N') = 'N'
1057: AND NVL(PRL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED' /* BUG:13019044 Added condition of Finally Closed requisition lines */
1058: UNION ALL
1059: SELECT 'PO/REQ Linked'
1060: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
1061: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
1062: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
1063: AND PRI.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id
1064: AND (p_op_seq_num is NULL OR PRI.WIP_OPERATION_SEQ_NUM = p_op_seq_num);

Line 2212: FROM po_requisitions_interface_all

2208: p_is_scrap_txn IS NULL OR p_is_scrap_txn = WIP_CONSTANTS.NO) THEN
2209:
2210: SELECT count(*)
2211: INTO l_pending_recs
2212: FROM po_requisitions_interface_all
2213: WHERE wip_entity_id = p_job_id
2214: AND (p_repetitive_id IS NULL OR
2215: wip_repetitive_schedule_id = p_repetitive_id);
2216:

Line 2221: 'PO_REQUISITIONS_INTERFACE_ALL';

2217: IF(l_pending_recs <> 0) THEN
2218: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2219: fnd_msg_pub.add;
2220: l_errMsg := 'There are some pending records in ' ||
2221: 'PO_REQUISITIONS_INTERFACE_ALL';
2222: raise fnd_api.g_exc_unexpected_error;
2223: END IF;
2224: end if; /* if((p_is_scrap_txn = WIP_CONSTANTS.YES AND */
2225:

Line 2637: FROM po_requisitions_interface_all

2633: fnd_msg_pub.add;
2634: ELSE
2635: SELECT count(*)
2636: INTO l_pending_recs
2637: FROM po_requisitions_interface_all
2638: WHERE wip_entity_id = p_job_id;
2639: IF(l_pending_recs <> 0) THEN
2640: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2641: fnd_msg_pub.add;

Line 2708: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

2704: AND (p_op_seq_num is NULL
2705: OR PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num))
2706: AND NOT EXISTS
2707: (SELECT '1'
2708: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
2709: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
2710: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
2711: AND (p_op_seq_num is NULL
2712: OR PRI.WIP_OPERATION_SEQ_NUM = p_op_seq_num));

Line 2739: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

2735: AND (p_op_seq_num is NULL
2736: OR PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num))
2737: AND NOT EXISTS
2738: (SELECT '1'
2739: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
2740: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
2741: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
2742: AND PRI.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id
2743: AND (p_op_seq_num is NULL