APPS.RCV_RMA_TRANSACTIONS dependencies on OE_SYS_PARAMETERS

Line 36: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)

32: AND oeh.open_flag = 'Y'
33: AND oel.line_category_code = 'RETURN'
34: AND oel.open_flag = 'Y'
35: AND oel.flow_status_code = 'AWAITING_RETURN'
36: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)
37: AND msi.inventory_item_id = oel.inventory_item_id;
38:
39: -- specs for package level procedures
40: -- helpers for derive_rma_line

Line 1076: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)

1072: AND oel.line_type_id = olt.transaction_type_id
1073: AND olt.transaction_type_code = 'LINE'
1074: AND olt.transaction_type_id = t.transaction_type_id
1075: AND t.LANGUAGE = USERENV('LANG')
1076: AND msi.organization_id = oe_sys_parameters.VALUE('MASTER_ORGANIZATION_ID', oel.org_id)
1077: AND msi.inventory_item_id = oel.inventory_item_id
1078: AND ( oel.ordered_item_id = NVL(v_customer_item_id, oel.ordered_item_id)
1079: OR oel.ordered_item_id IS NULL)
1080: AND oel.booked_flag = 'Y'