DBA Data[Home] [Help]

APPS.PO_WF_PO_CHARGE_ACC dependencies on WIP_REPETITIVE_SCHEDULES

Line 1018: FROM WIP_REPETITIVE_SCHEDULES

1014: IF (x_wip_schedule_account IS NULL) THEN
1015: IF (x_bom_cost_element_id LIKE '5') THEN
1016: BEGIN
1017: SELECT OVERHEAD_ACCOUNT INTO x_wip_schedule_account
1018: FROM WIP_REPETITIVE_SCHEDULES
1019: WHERE ORGANIZATION_ID = x_destination_organization_id
1020: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1021: AND '2' = NVL(x_wip_entity_type,'1')
1022: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1035: FROM WIP_REPETITIVE_SCHEDULES

1031: IF (x_wip_schedule_account IS NULL) THEN
1032: IF (x_bom_cost_element_id LIKE '4') THEN
1033: BEGIN
1034: SELECT OUTSIDE_PROCESSING_ACCOUNT INTO x_wip_schedule_account
1035: FROM WIP_REPETITIVE_SCHEDULES
1036: WHERE ORGANIZATION_ID = TO_NUMBER(x_destination_organization_id)
1037: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1038: AND '2' = NVL(x_wip_entity_type,'1')
1039: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1051: FROM WIP_REPETITIVE_SCHEDULES

1047: IF (x_wip_schedule_account IS NULL) THEN
1048: IF (x_bom_cost_element_id LIKE '3') THEN
1049: BEGIN
1050: SELECT RESOURCE_ACCOUNT INTO x_wip_schedule_account
1051: FROM WIP_REPETITIVE_SCHEDULES
1052: WHERE ORGANIZATION_ID = x_destination_organization_id
1053: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1054: AND '2' = NVL(x_wip_entity_type,'1')
1055: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1068: FROM WIP_REPETITIVE_SCHEDULES

1064: IF (x_wip_schedule_account IS NULL) THEN
1065: IF (x_bom_cost_element_id LIKE '2') THEN
1066: BEGIN
1067: SELECT MATERIAL_OVERHEAD_ACCOUNT INTO x_wip_schedule_account
1068: FROM WIP_REPETITIVE_SCHEDULES
1069: WHERE ORGANIZATION_ID = TO_NUMBER(x_destination_organization_id)
1070: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1071: AND '2' = NVL(x_wip_entity_type,'1')
1072: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1085: FROM WIP_REPETITIVE_SCHEDULES

1081: IF (x_wip_schedule_account IS NULL) THEN
1082: IF (x_bom_cost_element_id LIKE '1') THEN
1083: BEGIN
1084: SELECT MATERIAL_ACCOUNT INTO x_wip_schedule_account
1085: FROM WIP_REPETITIVE_SCHEDULES
1086: WHERE ORGANIZATION_ID = x_destination_organization_id
1087: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1088: AND '2' = NVL(x_wip_entity_type,'2')
1089: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)