DBA Data[Home] [Help]

APPS.RLM_DP_SV dependencies on RLM_INTERFACE_LINES

Line 65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,

61: -- ER 3992531: Added min_start_date_time to the following record structure.
62:
63: TYPE t_Group_rec IS RECORD(
64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,

Line 66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,

62:
63: TYPE t_Group_rec IS RECORD(
64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,

Line 67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,

63: TYPE t_Group_rec IS RECORD(
64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,

Line 68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,

64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,

Line 69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,

65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,

Line 70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,

66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,

Line 71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,

67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,

Line 72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,

68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,

Line 73: order_header_id rlm_interface_lines.order_header_id%TYPE,

69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,

Line 74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,

70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,

Line 78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,

74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,
79: --need for forecast module
80: bill_to_site_use_id rlm_interface_lines.bill_to_site_use_id%TYPE,
81: bill_to_address_id rlm_interface_lines.bill_to_address_id%TYPE,
82: match_within rlm_cust_shipto_terms.match_within_key%TYPE,

Line 80: bill_to_site_use_id rlm_interface_lines.bill_to_site_use_id%TYPE,

76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,
79: --need for forecast module
80: bill_to_site_use_id rlm_interface_lines.bill_to_site_use_id%TYPE,
81: bill_to_address_id rlm_interface_lines.bill_to_address_id%TYPE,
82: match_within rlm_cust_shipto_terms.match_within_key%TYPE,
83: match_within_rec rlm_core_sv.t_Match_rec,
84: match_across rlm_cust_shipto_terms.match_across_key%TYPE,

Line 81: bill_to_address_id rlm_interface_lines.bill_to_address_id%TYPE,

77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,
79: --need for forecast module
80: bill_to_site_use_id rlm_interface_lines.bill_to_site_use_id%TYPE,
81: bill_to_address_id rlm_interface_lines.bill_to_address_id%TYPE,
82: match_within rlm_cust_shipto_terms.match_within_key%TYPE,
83: match_within_rec rlm_core_sv.t_Match_rec,
84: match_across rlm_cust_shipto_terms.match_across_key%TYPE,
85: match_across_rec rlm_core_sv.t_Match_rec,

Line 93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,

89: frozen_days NUMBER,
90: isSourced BOOLEAN,
91: roll_forward_frozen_flag VARCHAR2(1),
92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );

Line 94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991

90: isSourced BOOLEAN,
91: roll_forward_frozen_flag VARCHAR2(1),
92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );
98: g_md_total NUMBER:=0;

Line 95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991

91: roll_forward_frozen_flag VARCHAR2(1),
92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );
98: g_md_total NUMBER:=0;
99: g_mf_total NUMBER:=0;

Line 96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE

92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );
98: g_md_total NUMBER:=0;
99: g_mf_total NUMBER:=0;
100: g_rd_total NUMBER:=0;