DBA Data[Home] [Help]

APPS.PO_WF_PO_CHARGE_ACC dependencies on WIP_REPETITIVE_SCHEDULES

Line 1012: FROM WIP_REPETITIVE_SCHEDULES

1008: IF (x_wip_schedule_account IS NULL) THEN
1009: IF (x_bom_cost_element_id LIKE '5') THEN
1010: BEGIN
1011: SELECT OVERHEAD_ACCOUNT INTO x_wip_schedule_account
1012: FROM WIP_REPETITIVE_SCHEDULES
1013: WHERE ORGANIZATION_ID = x_destination_organization_id
1014: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1015: AND '2' = NVL(x_wip_entity_type,'1')
1016: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1029: FROM WIP_REPETITIVE_SCHEDULES

1025: IF (x_wip_schedule_account IS NULL) THEN
1026: IF (x_bom_cost_element_id LIKE '4') THEN
1027: BEGIN
1028: SELECT OUTSIDE_PROCESSING_ACCOUNT INTO x_wip_schedule_account
1029: FROM WIP_REPETITIVE_SCHEDULES
1030: WHERE ORGANIZATION_ID = TO_NUMBER(x_destination_organization_id)
1031: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1032: AND '2' = NVL(x_wip_entity_type,'1')
1033: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1045: FROM WIP_REPETITIVE_SCHEDULES

1041: IF (x_wip_schedule_account IS NULL) THEN
1042: IF (x_bom_cost_element_id LIKE '3') THEN
1043: BEGIN
1044: SELECT RESOURCE_ACCOUNT INTO x_wip_schedule_account
1045: FROM WIP_REPETITIVE_SCHEDULES
1046: WHERE ORGANIZATION_ID = x_destination_organization_id
1047: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1048: AND '2' = NVL(x_wip_entity_type,'1')
1049: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1062: FROM WIP_REPETITIVE_SCHEDULES

1058: IF (x_wip_schedule_account IS NULL) THEN
1059: IF (x_bom_cost_element_id LIKE '2') THEN
1060: BEGIN
1061: SELECT MATERIAL_OVERHEAD_ACCOUNT INTO x_wip_schedule_account
1062: FROM WIP_REPETITIVE_SCHEDULES
1063: WHERE ORGANIZATION_ID = TO_NUMBER(x_destination_organization_id)
1064: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1065: AND '2' = NVL(x_wip_entity_type,'1')
1066: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)

Line 1079: FROM WIP_REPETITIVE_SCHEDULES

1075: IF (x_wip_schedule_account IS NULL) THEN
1076: IF (x_bom_cost_element_id LIKE '1') THEN
1077: BEGIN
1078: SELECT MATERIAL_ACCOUNT INTO x_wip_schedule_account
1079: FROM WIP_REPETITIVE_SCHEDULES
1080: WHERE ORGANIZATION_ID = x_destination_organization_id
1081: AND (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
1082: AND '2' = NVL(x_wip_entity_type,'2')
1083: AND REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)