[Home] [Help]
713: last_updated_by,
714: creation_date,
715: created_by,
716: last_update_login,
717: standard_operation_id,
718: department_id ,
719: operation_lead_time_percent,
720: minimum_transfer_quantity,
721: count_point_type ,
771: gUserId,
772: sysdate,
773: gUserId,
774: gLoginId,
775: os1.standard_operation_id,
776: os1.department_id,
777: os1.operation_lead_time_percent,
778: os1.minimum_transfer_quantity,
779: os1.count_point_type,
868: last_updated_by,
869: creation_date,
870: created_by,
871: last_update_login,
872: standard_operation_id,
873: department_id ,
874: operation_lead_time_percent,
875: minimum_transfer_quantity,
876: count_point_type ,
926: gUserId,
927: sysdate,
928: gUserId,
929: gLoginId,
930: os1.standard_operation_id,
931: os1.department_id,
932: os1.operation_lead_time_percent,
933: os1.minimum_transfer_quantity,
934: os1.count_point_type,
1079: last_updated_by,
1080: creation_date,
1081: created_by,
1082: last_update_login,
1083: standard_operation_id,
1084: department_id ,
1085: operation_lead_time_percent,
1086: minimum_transfer_quantity,
1087: count_point_type ,
1138: gUserId,
1139: sysdate,
1140: gUserId,
1141: gLoginId,
1142: os1.standard_operation_id,
1143: os1.department_id,
1144: os1.operation_lead_time_percent,
1145: os1.minimum_transfer_quantity,
1146: os1.count_point_type,
1226: )
1227: )
1228: AND si2.inventory_item_id = ic1.component_item_id
1229: AND si2.organization_id = b1.organization_id
1230: AND si2.bom_item_type = 4 -- standard
1231: AND os1.option_dependent_flag = 1
1232: /* one-to-many BOM components to Rtg operations */
1233: AND
1234: (
1379: last_updated_by,
1380: creation_date,
1381: created_by,
1382: last_update_login,
1383: standard_operation_id,
1384: department_id ,
1385: operation_lead_time_percent,
1386: minimum_transfer_quantity,
1387: count_point_type ,
1436: gUserId, /* last updated by */
1437: sysdate, /* creation date */
1438: gUserId, /* created by */
1439: gLoginId, /* last update login */
1440: os1.standard_operation_id,
1441: os1.department_id,
1442: os1.operation_lead_time_percent,
1443: os1.minimum_transfer_quantity,
1444: os1.count_point_type,
1552: last_updated_by,
1553: creation_date,
1554: created_by,
1555: last_update_login,
1556: standard_operation_id,
1557: department_id ,
1558: operation_lead_time_percent,
1559: minimum_transfer_quantity,
1560: count_point_type ,
1609: gUserId,
1610: sysdate,
1611: gUserID,
1612: gLoginId,
1613: os1.standard_operation_id,
1614: os1.department_id,
1615: os1.operation_lead_time_percent,
1616: os1.minimum_transfer_quantity,
1617: os1.count_point_type,
1716: last_updated_by,
1717: creation_date,
1718: created_by,
1719: last_update_login,
1720: standard_operation_id,
1721: department_id ,
1722: operation_lead_time_percent,
1723: minimum_transfer_quantity,
1724: count_point_type ,
1774: gUserId,
1775: sysdate,
1776: gUserID,
1777: gLoginId,
1778: os1.standard_operation_id,
1779: os1.department_id,
1780: os1.operation_lead_time_percent,
1781: os1.minimum_transfer_quantity,
1782: os1.count_point_type,
1924: last_updated_by,
1925: creation_date,
1926: created_by,
1927: last_update_login,
1928: standard_operation_id,
1929: department_id ,
1930: operation_lead_time_percent,
1931: minimum_transfer_quantity,
1932: count_point_type ,
1982: gUserId,
1983: sysdate,
1984: gUserID,
1985: gLoginId,
1986: os1.standard_operation_id,
1987: os1.department_id,
1988: os1.operation_lead_time_percent,
1989: os1.minimum_transfer_quantity,
1990: os1.count_point_type,
2060: )
2061: )
2062: AND si2.inventory_item_id = ic1.component_item_id
2063: AND si2.organization_id = b1.organization_id
2064: AND si2.bom_item_type = 4 /* standard */
2065: AND or1.assembly_item_id = b1.assembly_item_id
2066: AND or1.organization_id = b1.organization_id
2067: AND or1.alternate_routing_designator is null
2068: AND nvl(or1.cfm_routing_flag,2) = lCfmRtgFlag /*ensure correct OC rtgs*/
2227: last_updated_by,
2228: creation_date,
2229: created_by,
2230: last_update_login,
2231: standard_operation_id,
2232: department_id ,
2233: operation_lead_time_percent,
2234: minimum_transfer_quantity,
2235: count_point_type ,
2284: gUserId, /* last updated by */
2285: sysdate, /* creation date */
2286: gUserID, /* created by */
2287: gLoginId, /* last update login */
2288: os1.standard_operation_id,
2289: os1.department_id,
2290: os1.operation_lead_time_percent,
2291: os1.minimum_transfer_quantity,
2292: os1.count_point_type,
2560: operation_sequence_id,
2561: resource_seq_num,
2562: resource_id ,
2563: activity_id,
2564: standard_rate_flag,
2565: assigned_units ,
2566: usage_rate_or_amount,
2567: usage_rate_or_amount_inverse,
2568: basis_type,
2604: bor.resource_seq_num,
2605: bor.resource_id,
2606: /* resource id */
2607: bor.activity_id,
2608: bor.standard_rate_flag,
2609: bor.assigned_units,
2610: bor.usage_rate_or_amount,
2611: bor.usage_rate_or_amount_inverse,
2612: bor.basis_type,
2668: --scheduling_seq_num,
2669: schedule_seq_num,
2670: replacement_group_num,
2671: activity_id,
2672: standard_rate_flag,
2673: assigned_units,
2674: usage_rate_or_amount,
2675: usage_rate_or_amount_inverse,
2676: basis_type,
2713: --bsor.scheduling_seq_num,
2714: bsor.schedule_seq_num,
2715: bsor.replacement_group_num,
2716: bsor.activity_id,
2717: bsor.standard_rate_flag,
2718: bsor.assigned_units,
2719: bsor.usage_rate_or_amount,
2720: bsor.usage_rate_or_amount_inverse,
2721: bsor.basis_type,