APPS.PO_WF_PO_CHARGE_ACC dependencies on WIP_DISCRETE_JOBS

Line 765: FROM WIP_DISCRETE_JOBS

761:
762: BEGIN
763: SELECT outside_processing_account
764: INTO x_wip_job_account
765: FROM WIP_DISCRETE_JOBS
766: WHERE ORGANIZATION_ID = x_destination_organization_id
767: AND WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
768: AND OUTSIDE_PROCESSING_ACCOUNT <> -1;
769: EXCEPTION

Line 820: FROM WIP_DISCRETE_JOBS

816: IF (x_wip_job_account IS NULL) THEN
817: IF (x_bom_cost_element_id LIKE '5') THEN
818: BEGIN
819: SELECT OVERHEAD_ACCOUNT INTO x_wip_job_account
820: FROM WIP_DISCRETE_JOBS
821: WHERE ORGANIZATION_ID = x_destination_organization_id
822: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
823: AND OVERHEAD_ACCOUNT <> -1
824: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 835: FROM WIP_DISCRETE_JOBS

831: IF (x_wip_job_account IS NULL) THEN
832: IF (x_bom_cost_element_id LIKE '4') THEN
833: BEGIN
834: SELECT outside_processing_account INTO x_wip_job_account
835: FROM WIP_DISCRETE_JOBS
836: WHERE ORGANIZATION_ID = x_destination_organization_id
837: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
838: AND OUTSIDE_PROCESSING_ACCOUNT <> -1
839: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 850: FROM WIP_DISCRETE_JOBS

846: IF (x_wip_job_account IS NULL) THEN
847: IF (x_bom_cost_element_id LIKE '3') THEN
848: BEGIN
849: SELECT RESOURCE_ACCOUNT INTO x_wip_job_account
850: FROM WIP_DISCRETE_JOBS
851: WHERE ORGANIZATION_ID = x_destination_organization_id
852: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
853: AND RESOURCE_ACCOUNT <> -1
854: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 865: FROM WIP_DISCRETE_JOBS

861: IF (x_wip_job_account IS NULL) THEN
862: IF (x_bom_cost_element_id LIKE '2') THEN
863: BEGIN
864: SELECT MATERIAL_OVERHEAD_ACCOUNT INTO x_wip_job_account
865: FROM WIP_DISCRETE_JOBS
866: WHERE ORGANIZATION_ID = x_destination_organization_id
867: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
868: AND MATERIAL_OVERHEAD_ACCOUNT <> -1
869: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 880: FROM WIP_DISCRETE_JOBS

876: IF (x_wip_job_account IS NULL) THEN
877: IF (x_bom_cost_element_id LIKE '1') THEN
878: BEGIN
879: SELECT MATERIAL_ACCOUNT INTO x_wip_job_account
880: FROM WIP_DISCRETE_JOBS
881: WHERE ORGANIZATION_ID = x_destination_organization_id
882: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
883: AND MATERIAL_ACCOUNT <> -1
884: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));