APPS.PO_WF_PO_CHARGE_ACC dependencies on WIP_DISCRETE_JOBS

Line 771: FROM WIP_DISCRETE_JOBS

767:
768: BEGIN
769: SELECT outside_processing_account
770: INTO x_wip_job_account
771: FROM WIP_DISCRETE_JOBS
772: WHERE ORGANIZATION_ID = x_destination_organization_id
773: AND WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
774: AND OUTSIDE_PROCESSING_ACCOUNT <> -1;
775: EXCEPTION

Line 826: FROM WIP_DISCRETE_JOBS

822: IF (x_wip_job_account IS NULL) THEN
823: IF (x_bom_cost_element_id LIKE '5') THEN
824: BEGIN
825: SELECT OVERHEAD_ACCOUNT INTO x_wip_job_account
826: FROM WIP_DISCRETE_JOBS
827: WHERE ORGANIZATION_ID = x_destination_organization_id
828: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
829: AND OVERHEAD_ACCOUNT <> -1
830: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 841: FROM WIP_DISCRETE_JOBS

837: IF (x_wip_job_account IS NULL) THEN
838: IF (x_bom_cost_element_id LIKE '4') THEN
839: BEGIN
840: SELECT outside_processing_account INTO x_wip_job_account
841: FROM WIP_DISCRETE_JOBS
842: WHERE ORGANIZATION_ID = x_destination_organization_id
843: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
844: AND OUTSIDE_PROCESSING_ACCOUNT <> -1
845: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 856: FROM WIP_DISCRETE_JOBS

852: IF (x_wip_job_account IS NULL) THEN
853: IF (x_bom_cost_element_id LIKE '3') THEN
854: BEGIN
855: SELECT RESOURCE_ACCOUNT INTO x_wip_job_account
856: FROM WIP_DISCRETE_JOBS
857: WHERE ORGANIZATION_ID = x_destination_organization_id
858: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
859: AND RESOURCE_ACCOUNT <> -1
860: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 871: FROM WIP_DISCRETE_JOBS

867: IF (x_wip_job_account IS NULL) THEN
868: IF (x_bom_cost_element_id LIKE '2') THEN
869: BEGIN
870: SELECT MATERIAL_OVERHEAD_ACCOUNT INTO x_wip_job_account
871: FROM WIP_DISCRETE_JOBS
872: WHERE ORGANIZATION_ID = x_destination_organization_id
873: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
874: AND MATERIAL_OVERHEAD_ACCOUNT <> -1
875: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line 886: FROM WIP_DISCRETE_JOBS

882: IF (x_wip_job_account IS NULL) THEN
883: IF (x_bom_cost_element_id LIKE '1') THEN
884: BEGIN
885: SELECT MATERIAL_ACCOUNT INTO x_wip_job_account
886: FROM WIP_DISCRETE_JOBS
887: WHERE ORGANIZATION_ID = x_destination_organization_id
888: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
889: AND MATERIAL_ACCOUNT <> -1
890: AND NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));