[Home] [Help]
729: last_updated_by,
730: creation_date,
731: created_by,
732: last_update_login,
733: standard_operation_id,
734: department_id ,
735: operation_lead_time_percent,
736: minimum_transfer_quantity,
737: count_point_type ,
787: gUserId,
788: sysdate,
789: gUserId,
790: gLoginId,
791: os1.standard_operation_id,
792: os1.department_id,
793: os1.operation_lead_time_percent,
794: os1.minimum_transfer_quantity,
795: os1.count_point_type,
884: last_updated_by,
885: creation_date,
886: created_by,
887: last_update_login,
888: standard_operation_id,
889: department_id ,
890: operation_lead_time_percent,
891: minimum_transfer_quantity,
892: count_point_type ,
944: gUserId,
945: sysdate,
946: gUserId,
947: gLoginId,
948: os1.standard_operation_id,
949: os1.department_id,
950: os1.operation_lead_time_percent,
951: os1.minimum_transfer_quantity,
952: os1.count_point_type,
1097: last_updated_by,
1098: creation_date,
1099: created_by,
1100: last_update_login,
1101: standard_operation_id,
1102: department_id ,
1103: operation_lead_time_percent,
1104: minimum_transfer_quantity,
1105: count_point_type ,
1156: gUserId,
1157: sysdate,
1158: gUserId,
1159: gLoginId,
1160: os1.standard_operation_id,
1161: os1.department_id,
1162: os1.operation_lead_time_percent,
1163: os1.minimum_transfer_quantity,
1164: os1.count_point_type,
1244: )
1245: )
1246: AND si2.inventory_item_id = ic1.component_item_id
1247: AND si2.organization_id = b1.organization_id
1248: AND si2.bom_item_type = 4 -- standard
1249: AND os1.option_dependent_flag = 1
1250: /* one-to-many BOM components to Rtg operations */
1251: AND
1252: (
1400: last_updated_by,
1401: creation_date,
1402: created_by,
1403: last_update_login,
1404: standard_operation_id,
1405: department_id ,
1406: operation_lead_time_percent,
1407: minimum_transfer_quantity,
1408: count_point_type ,
1457: gUserId, /* last updated by */
1458: sysdate, /* creation date */
1459: gUserId, /* created by */
1460: gLoginId, /* last update login */
1461: os1.standard_operation_id,
1462: os1.department_id,
1463: os1.operation_lead_time_percent,
1464: os1.minimum_transfer_quantity,
1465: os1.count_point_type,
1572: last_updated_by,
1573: creation_date,
1574: created_by,
1575: last_update_login,
1576: standard_operation_id,
1577: department_id ,
1578: operation_lead_time_percent,
1579: minimum_transfer_quantity,
1580: count_point_type ,
1629: gUserId,
1630: sysdate,
1631: gUserID,
1632: gLoginId,
1633: os1.standard_operation_id,
1634: os1.department_id,
1635: os1.operation_lead_time_percent,
1636: os1.minimum_transfer_quantity,
1637: os1.count_point_type,
1735: last_updated_by,
1736: creation_date,
1737: created_by,
1738: last_update_login,
1739: standard_operation_id,
1740: department_id ,
1741: operation_lead_time_percent,
1742: minimum_transfer_quantity,
1743: count_point_type ,
1793: gUserId,
1794: sysdate,
1795: gUserID,
1796: gLoginId,
1797: os1.standard_operation_id,
1798: os1.department_id,
1799: os1.operation_lead_time_percent,
1800: os1.minimum_transfer_quantity,
1801: os1.count_point_type,
1942: last_updated_by,
1943: creation_date,
1944: created_by,
1945: last_update_login,
1946: standard_operation_id,
1947: department_id ,
1948: operation_lead_time_percent,
1949: minimum_transfer_quantity,
1950: count_point_type ,
2000: gUserId,
2001: sysdate,
2002: gUserID,
2003: gLoginId,
2004: os1.standard_operation_id,
2005: os1.department_id,
2006: os1.operation_lead_time_percent,
2007: os1.minimum_transfer_quantity,
2008: os1.count_point_type,
2078: )
2079: )
2080: AND si2.inventory_item_id = ic1.component_item_id
2081: AND si2.organization_id = b1.organization_id
2082: AND si2.bom_item_type = 4 /* standard */
2083: AND or1.assembly_item_id = b1.assembly_item_id
2084: AND or1.organization_id = b1.organization_id
2085: AND or1.alternate_routing_designator is null
2086: AND nvl(or1.cfm_routing_flag,2) = lCfmRtgFlag /*ensure correct OC rtgs*/
2243: last_updated_by,
2244: creation_date,
2245: created_by,
2246: last_update_login,
2247: standard_operation_id,
2248: department_id ,
2249: operation_lead_time_percent,
2250: minimum_transfer_quantity,
2251: count_point_type ,
2300: gUserId, /* last updated by */
2301: sysdate, /* creation date */
2302: gUserID, /* created by */
2303: gLoginId, /* last update login */
2304: os1.standard_operation_id,
2305: os1.department_id,
2306: os1.operation_lead_time_percent,
2307: os1.minimum_transfer_quantity,
2308: os1.count_point_type,
2568: operation_sequence_id,
2569: resource_seq_num,
2570: resource_id ,
2571: activity_id,
2572: standard_rate_flag,
2573: assigned_units ,
2574: usage_rate_or_amount,
2575: usage_rate_or_amount_inverse,
2576: basis_type,
2612: bor.resource_seq_num,
2613: bor.resource_id,
2614: /* resource id */
2615: bor.activity_id,
2616: bor.standard_rate_flag,
2617: bor.assigned_units,
2618: bor.usage_rate_or_amount,
2619: bor.usage_rate_or_amount_inverse,
2620: bor.basis_type,
2677: --scheduling_seq_num,
2678: schedule_seq_num,
2679: replacement_group_num,
2680: activity_id,
2681: standard_rate_flag,
2682: assigned_units,
2683: usage_rate_or_amount,
2684: usage_rate_or_amount_inverse,
2685: basis_type,
2722: --bsor.scheduling_seq_num,
2723: bsor.schedule_seq_num,
2724: bsor.replacement_group_num,
2725: bsor.activity_id,
2726: bsor.standard_rate_flag,
2727: bsor.assigned_units,
2728: bsor.usage_rate_or_amount,
2729: bsor.usage_rate_or_amount_inverse,
2730: bsor.basis_type,